Home > SSIS > Accessing FTP server using script – SSIS

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.

Implementation

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

pic1

Step 2: Add this code in a Script Task in the package. You should change the value in the box with your requirements.

pic2

Download code

Step 3: Execute package

pic3

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: