File Connection Manager in SSIS

The File Connection Manager in SSIS enables SQL Server Integration Services packages to connect with the Files and Folders present in the File System. The SSIS File Connection Manager allows us to connect with existing files and folders and creates New files and folders at run time.

TIP: In SSIS, File System Task uses File Connection Manager 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 the File Connection Manager in SSIS (SQL Server Integration Services)

Once you create a new Project, if you look at the Solution Explorer, we have three folders. For now, let us concentrate on the Connection Managers Folder.

File Connection Manager in SSIS 1

Right-click on the Connection Managers folder and select the New Connection Manager option from the context menu.

File Connection Manager in SSIS 2

When you click on the New Connection Manager option, an Add Connection Manager window form will open. Use this to select the connections managers from the list.

Here, we have to select the File Connection Manager from the provided list

File Connection Manager in SSIS 3

Once you choose the Connection Managers for files, the SSIS File Connection Manager Editor opens in a new window. We have to configure the connection with files and folders using this editor.

File Connection Manager in SSIS 4

Available File and Folder Options

  • File: This text box will display the full path of the selected file or folder. For more information on File System Task >> Click Here.
  • Browse: This button will traverse the file system to locate the required file or folder.
  • Usage Type: File Connection Manager provides four different options to connect with the files and folders. The below table explains their functionality in detail:
Usage TypeDescription
Create FileThis option creates a new file at run time. For example, If we are renaming the file, then we have to create a new file with a new name.
Existing FileThis option creates a new file at run time. For example, If we are renaming the file, we have to create a new file with a new name.
Create FolderThis SSIS File Connection Manager option creates a new folder at run time. For example, If we want to copy or move directory content from one location to another, we can create a new folder with a better name.
Existing Folder

This option will help to work with an already existing folder in the file system. For instance, If we want to copy or move a directory from one location to another, use this option to select the required folder.

File Connection Manager in SSIS 5

If you select the Existing File option, when you click on the Browse button, it will open the Select File window to select the existing files.

Choose text File from local Hard rive 6

If you select the Existing Folder option, when you click on the Browse button, it opens the Browse For Folder window to choose the existing folders.

Choose Existing Folder 7

Once you have selected the required file, Click on the OK button

Click the Ok to Close the window 8

Click the OK button to finish configuring the File Connection Manager.

File Connection Manager in SSIS 9

From the above screenshot, you can observe that we successfully created File Connection Manager in SSIS.

Comments are closed.