File connection Manager in SSIS package

 A File connection manager enables a package to reference an existing file or folder, or to create a file or folder at run time. Using the File Connection manager we can create the any type of file connection manager like txt file, CSV file, Excel File or access file. 

The FileUsageType property of the File connection manager specifies how the file connection is used. The File connection manager can create a file, create a folder, use an existing file, or use an existing folder.

The following table lists the values of FileUsageType.

 

Value	Description
0	File connection manager uses an existing file
1	File connection manager creates a file
2	File connection manager uses an existing folder
3	File connection manager creates a folder

Let’s see the example.

Creating connection manager for Txt file.

  

 Creating connection manager for CSV file.

    

Creating connection manager for Excel file.

   

Creating connection manager for Access file.

  

Flat file connection manager we can create only CSV file or Txt file connection manager.