O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sending and receiving files through FTP: FTP Task

The FTP Task gives us the ability to send files from a local system to a remote host or retrieve them from a remote host to a local system. There are other types of operations such as creating a remote folder or local folder. This task is very handy because FTP is in use between many companies for sharing their data. A company may export all its data into some CSV files, ZIP them and put them on an FTP address, and another company may need to get those files from FTP. The FTP Task also provides a way to work with multiple files.

How to do it...

  1. Create new Integration Services project and name it R03_FTP Task.
  2. In the package Control Flow, drag-and-drop an FTP Task and name it FTP_ReceiveFiles.
  3. Double-click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required