Use FTP in a session that writes to flat file or XML file targets. You can stage the target files on the machine hosting the Integration Service before copying them to the FTP host.

When you stage target data, the Integration Service creates a target file locally and transfers it to the FTP host when the session completes. If you do not stage the target file, the Integration Service writes directly to the target file on the FTP host. If the network fails, you must run the session again.

If you have the Partitioning option, use FTP for multiple target partition instances. You can write to multiple target files or a merge file on the Integration Service or the FTP host.