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 2008 Forums
 SSIS and Import/Export (2008)
 copy files

Author  Topic 

daveofgv
Starting Member

6 Posts

Posted - 2011-04-20 : 23:41:52
I have about 500 to 1000 files that need to be copied from different directories. They are in the same directory, however, in different sub folders. I have a list of file names (343254343.tif) in an excel spreadsheet (column A). How can I have a SSIS package search for each file name and copy to another directory?

Please help if you can.

Thanks in advanced
daveofgv

I am learning new things about SQL everyday
   

- Advertisement -