Accessing FTP server using script – SSIS
FTP connection manager is used to configure and connect to a File Transfer Protocol (FTP) server. We also have FTP task in SSIS for the package to communicate with server. In this blog post, I am going to write VB.NET to communicate to FTP server with FTP connection manager. Because, code has more flexibility than the component.
I have already created a free FTP Account in http://www.filegenie.com/. I am going to use VB.NET code to search a file and download it from FTP Server.
Step 1: Configure FTP Connection
Step 2: Add this code in a Script Task in the package. You should change the value in the box with your requirements.
Step 3: Execute package