The SSIS FTP Connection Manager is used to establish connection with File Transfer Protocol server or simply say, FTP Server. This Connection Manger not only allows us to access the existing remote files and folder but also creates New files and folders at run time in SQL Server Integration Services.
Configuring SSIS FTP Connection Manager
In this example We are going to show, How to create or configure SSIS FTP Connection Manager.
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 and 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 to select the connections managers from the list it is provided.
Here we selected the FTP Connection Manager from the available list. Once we selected the FTP connection manager, another window form called FTP Connection Manager Editor will be opened to configure the connection.
FTP Connection Manger provides following options:
- Server Name: Please specify the Company FTP server name here. For example, it will be something like ftp.tutorialgateway.org
- Server Port: Please specify the Port number here. Client can access your FTP server using this available port (should be Open). By default it will be 21
- User Name: Please provide the user name to access the FTP Server. By default you can use the anonymous but in real-time, Your organization will provide these credentials or use the credentials you specified while configuring your FTP server.
- Password: Please provide the password to access the FTP Server.
- Use passive mode: If you unchecked this option (which is default) FTP Connection Manger will use Active mode otherwise, Passive mode.
- Retries: Please provide the number of retries. If it reaches maximum retries, Connection will Fail.
- Test Connection: Click on this button to check whether our connection is successful or not.
NOTE: If the connection is using active mode, Server will initiate the connection otherwise (Passive Mode), Client has to initiate the connection.
From the above screenshot you can observe that, We are using the localhost (Our local PC) as FTP Server and a custom port number. In real-time you have to select the Company’s FTP Server and provide the valid credentials given by your Admin person.
Let us test our established connection by clicking the Test Connection button. From the below screenshot you can observe that, Our credentials are Valid.
Click OK button to finish configuring the SSIS FTP Connection Manger.
From the above screenshot you can observe that, We successfully created SSIS FTP Connection Manager.
Thank You for Visiting Our Blog