if you use the same source and destination in the loop then it will add them to the same table.

If you need to read and write to different tables then...

I am not sure i have not use 7-zip...

For the parameters it would depend on the unzip util you are using, in that example the 'e' mean extract and the 'o' means overwirte.

so they are building up...

sorry I was typing the repsonse when you posted your answer so didn't see it until it was too late.

Glad it is sorted out .

you are trying to assign a default value (null) to a local varable

You can use any tool that supports comand line unzipping, i have used WinRar and as Jeff mentioned 7-Zip would work as well. You would use pretty much the...

there are a lot of ssis resource on

http://www.sqlis.com

in particular

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

unzipping shouldn't be a problem as you are just executing an application in the same way...

you can unzip in ssis, you can use the execute process task to execute the unzip application with a dynamic filename, you can also use a script...

i would create a SSIS packages to unzip the files to a working directory and then use the For-Each loop to loop through the files and import that data from...

have you checked the error log on the server that you are trying to connect to? there should be an error on there with a code that will...

yes you need to...

Have you check the logs on the sql server to see what the error is?

Ive tried to connect using windows authentication and also through a sql server account...

They are probably grilling to see if you can go the job properly and under pressure so that you do not make mistakes and then they get the blame.

However some...

you can check the time out value from this table

SELECT * FROM sys.database_mirroring

try using ISNUMERIC in the order by

SELECT * FROM yourTable

ORDER BY ISNUMERIC(yourCol), yourCol