Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 22 – Receive File using FTP Task in SSIS Package

 

This is part 22 of the series of article on SSIS. In this article we are going to see how to receive file from FTP task in SSIS.

Introduction

In this article we are going to see on how to use a FTP task in SSIS package to receive a file.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

[more]

Steps:

In this article we are going to see on how to use a FTP task container in packaging. FTP task is mainly used to do a file transfer using FTP. SSIS provides the in built task container to do a FTP of a file. Let’s jump start to see the on how to use the task in real time. Here im going to show a small example on how to configure a FTP task and receive a file.

Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use FTP task container. Drag and drop the FTP task as shown in the below screen.

clip_image001

Now double click on the task to open the property window and set the properties as shown in the below screen.

clip_image002

The above image is for setting the FTP Connection, end user need to provide the correct connection settings and click on the Test Connection to confirm if the connection is valid.

Now in the file transfer tab we need to set the property since in our example we are going to receive the file from FTP we need to set as below. Here input variable is used to get the path where we need to save the file.

clip_image003

Here once you have given valid credentials by running directly the package will do the necessary steps of receiving the files from FTP to the local folder.

Conclusion

So in this article we have seen on how to use the FTP task to receive a file from a site and save it in a local folder.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (3) -

Blair Christensen
Blair Christensen
11/8/2012 8:20:05 AM #

So are you going to actually show the file path setup?  You're leaving out more than 50% of the configuration - the part someone really needs - including input and output paths, etc.  Without that, this post is worthless and not a "tutorial".

Niv
Niv
3/12/2013 7:52:11 PM #

For FTP server name,is it compulsory that the server should be FTP or Any server like SQL server    is also allowed

Ultra SoundTech
Ultra SoundTech
9/5/2013 3:15:20 AM #

Following the tremendous technological improvement that occurred in recent decades concerning computing as nicely as the Internet in basic and satellite communication and optic fibers in certain, a straightforward choice was developed, an alternative that is handy, straightforward and enables performing several actions that were impossible in the past due to the luck of technological signifies without these measures. <a href="http://theultrasoundtechnician.com/diagnostic-medical-sonographers/">Ultra SoundTech School</a>. To facilitate trade amongst currency zones, there are exchange prices, which are the costs at which currencies (and the goods and solutions of person currency zones) can be exchanged against each and every other. So if there's a likelihood I'm going to want the money in a week or much less, I hold it in my checking account.

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter