[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1140
  • Last Modified:

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
1 Solution
GetRdoneAuthor Commented:
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

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

You can use ForEach loop to fetch each file name and store the file name in the variable

then in the Foreachloop use one execute sql task with select count(1) from table where columnname = @Variable

and have the output to another variable

Then while using the FileTask in the precedence constraints check the value of second variable if > 1 then do not perform otherwise perform

This will move only the files which will not be available in the table

Hope this will work

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now