Search code examples
ssisssis-2012ssis-2008

SSIS to get the particular file from multiple files and copy to different folder

my question is how we will create SSIS package to get the particular file from multiple files and copy to different folder Need Help

Solution

  • You can use File System Task in your package control flow.

    Configure the properties as below:

    DestinationConnection: Enter the full file path of the folder you want to move your file to e.g c:\Users\ToTest

    Operation: Change to Move file.

    SourceConnection: Enter the full file path of the folder where your file is, including the file name and extension e.g c:\Users\Test\testfile.csv