Viewing 15 posts - 16 through 30 (of 74 total)
I found this site to be very helpful with regards to zipped files.
Regards:
Mordred
Keep on Coding in the Free World
September 5, 2012 at 8:40 pm
August 30, 2012 at 11:27 am
Hi sqlstud,
Right click in the Connection Managers window and select New File Connection. Next, click browse and select the xlsb file. You can then use code...
Regards:
Mordred
Keep on Coding in the Free World
August 30, 2012 at 9:05 am
With changes I've made to my code this only takes about 5 or so seconds to complete now.
Regards:
Mordred
Keep on Coding in the Free World
August 29, 2012 at 1:50 pm
Hi Lowell and thanks. Can I ask why you pad the side of the string like that?
Regards:
Mordred
Keep on Coding in the Free World
August 29, 2012 at 1:47 pm
RBarryYoung (8/29/2012)
How many rows does this query return?
There are just over 2000 rows. I'm going to remove the redundant code iex = x + SCqryStr
I added that because I...
Regards:
Mordred
Keep on Coding in the Free World
August 29, 2012 at 1:23 pm
Ok so I think I've solved this one withIf SQLdr.HasRows Then
While SQLdr.Read()
...
Regards:
Mordred
Keep on Coding in the Free World
August 29, 2012 at 1:19 pm
I forgot to make sure that the code knows if there is another row to look at. Amended code:If SQLdr.HasRows Then
...
Regards:
Mordred
Keep on Coding in the Free World
August 29, 2012 at 1:06 pm
Thanks opc.three, I've nested another try catch statement that catches the time out and so far it I haven't had any problems. However, the process is a long one...
Regards:
Mordred
Keep on Coding in the Free World
August 27, 2012 at 10:21 am
I'm a Service Broker virgin and just did some quick reading about it and will need to study up about it. I'm not really sure about what more details...
Regards:
Mordred
Keep on Coding in the Free World
August 22, 2012 at 12:24 pm
I set the properties-Window Style to Hidden and now all is good in my hood.
Regards:
Mordred
Keep on Coding in the Free World
August 22, 2012 at 9:37 am
After dragging my knuckles through the dirt I, with the help of a co-worker, have figured this out. Instead of placing the path to be unzipped in the Arguments...
Regards:
Mordred
Keep on Coding in the Free World
August 21, 2012 at 3:35 pm
Thanks for the response! I have an unzip executable already in place but I am confused about the arguments I need to set in order to unzip the variable...
Regards:
Mordred
Keep on Coding in the Free World
August 20, 2012 at 10:10 pm
Does your output into Excel look like '35.33? That's the way it's flowing for me.
Regards:
Mordred
Keep on Coding in the Free World
August 17, 2012 at 9:38 am
This is the strangest problem I've seen with SSIS so far. Like you, I've formatted the column that is to hold the currency data and the source data is...
Regards:
Mordred
Keep on Coding in the Free World
August 17, 2012 at 9:29 am
Viewing 15 posts - 16 through 30 (of 74 total)