Downloading FTP Files in SSIS and unzipping them

Reply

gvamsimba Posted: 08-27-2009 12:50

rated by 0 users

HI, Can any one give me step by step approach
on creating a package in SSIS in order to download and unzip
the files from ftp into a certain folder dynamically ?

It would be really great if i could schedule it as well for
a certain time, if possible.

Many Thanks..

Reply

PedroCGD replied on 09-07-2009 12:37

rated by 0 users

Hi!

Sorry for the late answer... I'm really busy in this month.

Check the post on moving huge ammount of files...

Give more details.

Pedro

Reply

gvamsimba replied on 09-09-2009 11:50

rated by 0 users

HI Pedro,
             I checked your post on moving huge
amount of files..it is a good one,but only moves files,
whereas my requirement is to download the zipped files
from an FTP and then extract those zipped files,if possible ?

Many Thanks..

Reply

PedroCGD replied on 09-09-2009 11:56

rated by 0 users

Inside teh for each loop add a FTP task to get each file...

already tried?

regards,

Pedro