asked on

SSIS SQL copy specific files to new folder

I need to create a SSIS package that looks at file names in a shared folder and compares it to a filename stored in a SQL table. If the filename in the shared folder = the filename in the SQL table I need it to copy only those files from the shared folder location to another location. What SSIS task components should I be using to make this happen?
Thanks in Advance

Anuj

You should use "File System Task" to get this done.

Ref : http://www.exacthelp.com/2012/02/copy-file-in-file-system-in-ssis-by.html
Ref2 : http://www.bidn.com/blogs/KeithHyer/bidn-blog/2465/copy-and-rename-a-file-in-ssis-using-the-file-system-task

Thanks!

GetRdone

ASKER

I don't see how a file system task alone can get this done. I have used this to copy a folder to another folder but I need the package to be more selective and only copy files that are listed in a *.txt or a SQL table that = the filename in the shared folder.
so for example if my share folder has and the SQL database file has
001.jpg 001.jpg
002.jpg
003..jpg

I want only the 001.jpg copied to the new location.
Thanks I hopes this explains what I'm trying to do better.

ASKER CERTIFIED SOLUTION

Vikas Garg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial