Move files with SSIS to different directories dynamically based on excel file names

Question

How to move multiple excel files to different folders based on file name in ssis? means based on the file name it will move to respective folder.

Answer 1

Have you tried this?

In this you can see that you have to create a foreach loop, a script task a and a file system task to move the files to destination folder.

how to move files to different folders , based on matching filename and foldername in ssis

Answer 2

Using Foreach loop container

1. You have to add a for-each loop container to loop over files in a specific directory.

2. Choose the follow expression as a filename:

   *takeme*

3. Map the filename to a variable

4. Add a dataflow task inside the for each loop to transfer files
5. use the filename variable as a source

you can follow the detailed article at:

• http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx

if you want to add multiple filter follow my answer at:

• How to add multiple file extensions to the Files: input field in the Foreach loop container SSIS

Using a script task

or you can achieve this using a script task with a similar code: (i used VB.Net)

Public Sub Main()

    For Each strFile As String In IO.Directory.GetFiles("C:\New Folder\", "*takeme*", IO.SearchOption.AllDirectories)

        Dim filename As String = IO.Path.GetFileName(strFile)

        IO.File.Copy(strFile, "D:\New Folder\" & filename)

    Next

    Dts.TaskResult = ScriptResults.Success
End Sub