The File System Task in SSIS allows us to perform Ten types of Operations on Files and Folders. In this article We will show you, How to Copy Files Using File System Task in SSIS with example. To Copy the complete Directory, Please refer Copy Directory Using File System Task article.
TIP: In SSIS, Please use the For each Container to Copy multiple files from one location to another location.
We have File System Task Folder inside the MSBI Folder. Below screenshot shows you the data inside that folder. Our task is to Copy the cache.xml file inside the File System Task Folder to Copied Folder inside F Drive.
Files inside the Copied folder are:
Copy Files Using File System Task in SSIS
In order to Copy Files Using File System Task in SSIS, First Drag and drop the File System Task into the Control Flow region and rename it as Copy File Using File System Task in SSIS
Double click on it will open the File System Task Editor to configure it.
In this example, We are Copying single file so, Please change the operation property to Copy File as shown in the below screenshot
Let us configure the Source Connection by selecting the SourceConnection property. If you already created the File Connection Manager before then select the created one or If you stored the Source Connection in the Variable then, please change the IsSourcePathVariable property to TRUE and select the Variable Name.
Here, We haven’t created any connection Manager before so, We are selecting <New Connection..>.
Once you click on the <New Connection..> option, File Connection Manager Editor will be opened to configure it. In this example we are Copying existing file so we are selecting Existing File option from the Usage Type.
Click on the Browse button to select the Existing File from the file system.
From the above screenshot you can observe that, We selected the Cache.xml file inside the File System Task Folder
Click Ok to finish configuring the Source connection. Now we have to configure the Destination Connection so, Please select the DestinationConnection property. If you already created the File Connection Manager before then select the created one or If you stored the Destination Connection in the Variable then, please change the IsDestinationPathVariable property to TRUE and select the Variable Name.
Here, We haven’t created any connection Manager before so, We are selecting <New Connection..>.
In this example we are Copying existing file to the already existing folder so, we are selecting Existing Folder option from the Usage Type.
Click on the Browse button to select the Existing Folder from the file system.
From the above screenshot you can observe that, We selected the Copied Folder as the destination folder. Click Ok button to select it.
Click Ok to finish configuring the File Connection Manager for the destination.
Next, Click Ok to finish configuring the Copy Files Using File System Task in SSIS package. Let’s run and see whether we successfully Copied the Cache.xml file using the File System Task or Not.
Well, We successfully Copied the Cache.xml file present in the File System Task Folder to the Copied Folder.
Thank You for Visiting Our Blog.
