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
F5debug | A Webcast Series on Windows Phone which you should not miss

Floating FB popout byF5debug

A Webcast Series on Windows Phone which you should not miss


Microsoft has recently announced a Webcast Series on Windows Phone which a Windows Phone enthusiast should not miss this opportunity. This series is of 5 days and 2 hours on each day which covers in depth knowledge on Windows Phone for 1 hour and more importantly with another 1 hour of interactive session with the attendees. Its always a worth attending session on Windows Phone which provides an insight on developing our dream application to reality.          [more]

Details of the Session:

The session starts from 3rd September 2012 and ends by 7th September 2012 (5 days) and the timing would be from 3:00PM to 5:00PM IST (GMT+5:30) India time. So why waiting for the day, start registering for the session now

register

Agenda for the session:

Below is the complete details of the session:

Session 1 - Getting Started – Development Tools & Dev Center

  • Date - 03 September 2012
  • Timing – 3:00PM to 5:00PM IST (GMT+5:30) India
  • Duration – 2 hours
  • Presenter(s): Wriju Ghosh
  • Description : In this session we will walkthrough from scratch, installing the development tools, building the first app, testing it on the emulator, creating the marketplace account and submitting the app. The session emphasizes on the overall stages that a business/developer should be aware of.

Session 2 - Designing Apps for Windows Phone

  • Date - 04 September 2012
  • Timing – 3:00PM to 5:00PM IST (GMT+5:30) India
  • Duration – 2 hours
  • Presenter(s): Amar Nityananda
  • Description : In this session, we will talk about the design and user experience philosophy of Windows Phone. In this session developers and designers will learn what are things they should keep in mind to make their applications shine on the Windows Phone. We will also cover how to use expression tools, share design resources (icons, templates etc.) during this session.

Session 3 - Developing Apps for Windows Phone

  • Date - 05 September 2012
  • Timing – 3:00PM to 5:00PM IST (GMT+5:30) India
  • Duration – 2 hours
  • Presenter(s): Amar Nityananda
  • Description : In this session we will cover the core concepts of programming for Windows Phone platform. How to leverage the features like camera, launchers/choosers, Live tiles, Fast App Switching, tasks, various controls, Bing maps etc. This session will focus on the depth concepts of Windows Phone Development.

Session 4 - Performance analysis & optimization for Windows Phone apps

  • Date - 06 September 2012
  • Timing – 3:00PM to 5:00PM IST (GMT+5:30) India
  • Duration – 2 hours
  • Presenter(s): Goutham Upadhyaya
  • Description : In this session we will introduce performance analysis tool and APIs to developers and testers. This also explains how to capture performance data, understand, analyze the issues/roadblocks and optimize the apps.

Session 5 - Making your apps submission ready

  • Date - 07 September 2012
  • Timing – 3:00PM to 5:00PM IST (GMT+5:30) India
  • Duration – 2 hours
  • Presenter(s): Wriju Ghosh
  • Description : In this session we will explain things to keep in mind before you submit the app to Dev Center like certification criteria, using the market place test kit,  Trial API, Integrating Ads etc.

This series is an online webcast, which will be started with a session on the particular topic and later with the Q n A session through the Microsoft Live Meeting (Install the Live Meeting client before the session).

Hope this information will be useful to you, If interested please don’t forget to connect with me on Twitter, Facebook and GooglePlus for updates. Also subscribe to F5debug Newsletter to get all the updates delivered directly to your inbox. We won’t spam or share your email address as we respect your privacy.

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

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