You can create SSIS package to perform file related
operations like copy file or directory, create file or directory, delete file
or directory, rename file etc. You just need to drag File System Task item from
tool bar to control flow tab or simply double click on File System Task item from
tool bar. Double click on File System Task item it will open editor dialog
window. You can set source and destination connection properties based
on selected file operation. You
can see below the list of various file operations available to perform with file system
task.
Below is the File System Task editor dialog which displays
properties to be set to perform particular task. The available tasks for File
System Task are displayed in above image.
As per selected operation, you need to specify source and destination
connection or only specify source connection. You need to specify either
existing connection or create new connection. Below is the new file connection
dialog.
You can select usage type as create file, create folder,
existing file or existing folder. Specify file name with folder location. After setting all the parameters, you can execute package and your selected
file operation successfully completed.
Below is the video which explains how to create and execute file
system task with different file operations.
See Also –
