Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 FTP download multiple files

Author  Topic 

tpavan7329
Starting Member

18 Posts

Posted - 2011-07-22 : 18:16:56
Hello,
I have a requirement to download multiple files from FTP with file names starting with casmulmmddyyy_*.csv.gz. Can you please let me know if there is a way to download all the files into local machine and load them into one single table.

Is it possible to merge all the files into one single file(all the files have same format) and then load into one single table?

T Pavan Kumar
   

- Advertisement -