The File Connection Manager in SSIS enables SQL Server Integration Services packages to connect with the Files and Folders present in the File System. This Connection Manger not only allows us to connect with existing files and folder but also creates New files and folders at run time.
TIP: In SSIS, File System Task uses File Connection Manger only to connect with the Files and Folder.
Configuring File Connection Manager in SSIS
In this example We are going to show, How to create or configure File Connection Manager in SSIS (SQL Server Integration Services)
Once you created new Project under SSIS. If you look at the Solution explorer we have three folders. For now lets concentrate on the Connection Managers Folder.
Right click on the Connection Managers folder present in the solution explorer. Next, select the New Connection Manager option from the context menu.
When you click on the New Connection Manager option, an Add SSIS Connection Manager window form will be opened. Use this to select the connections managers from the list it is provided.
Here we have to select the File Connection Manager from the provided list
Once you selected the Connection Managers for files, File Connection Manager Editor will be opened in new window. Using this editor we have to configure the connection with files and folders.
- File: This text box will display the full path of the selected file or folder.
- Browse: This button will be used to traverse the file system to locate the required file or folder.
- Usage Type: File Connection Manager provides us four different options to connect with the files and folders. Below table explains their functionality in detail:
|Create File||This option will create new file at run time. For example, If we are renaming the file then we have to create new file with new name.|
|Existing File||This option will be helpful to work with already existing file in the file system. For example, If we want to copy or move file from one location to other then, we have to select this option.|
|Create Folder||This option will create new folder at run time. For example, If we want to copy or move directory content from one location to other, then we can create new folder with better name by select this option.|
|Existing Folder||This option will be helpful to work with already existing folder in the file system. For example, If we want to copy or move directory from one location to other, then we can use this option to select the required folder.|
If you select the Existing File option then, When you click on Browse button it will open the Select File window to select the existing files as shown in the below screenshot.
If you select the Existing Folder option then, When you click on Browse button it will open the Browse For Folder window to select the existing folders as shown below.
Once you selected the required file, Click on the Ok button
Click Ok button to finish configuring the File Connection Manger.
From the above screenshot you can observe that, We successfully created File Connection Manager in SSIS.
Thank you for Visiting Our Blog