I found this site to be very helpful with regards to zipped files.

Hi MrReddy,

Does this link help?

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...

With changes I've made to my code this only takes about 5 or so seconds to complete now.

Hi Lowell and thanks. Can I ask why you pad the side of the string like that?

There are just over 2000 rows. I'm going to remove the redundant code iex = x + SCqryStrI added that because I...

Ok so I think I've solved this one withIf SQLdr.HasRows Then

While SQLdr.Read()

...

I forgot to make sure that the code knows if there is another row to look at. Amended code:If SQLdr.HasRows Then

...

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...

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...

I set the properties-Window Style to Hidden and now all is good in my hood.

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...

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...

Does your output into Excel look like '35.33? That's the way it's flowing for me.

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...