The behavior of the Integration Service using FTP or SFTP depends on the way you configure the FTP or SFTP connection and the session. The Integration Service can use FTP or SFTP to access source and target files in the following ways:
. Stage source files on the machine hosting the Integration Service or access the source files directly from the FTP or SFTP host. Use a single source file or a file list that contains indirect source files for a single source instance.
Stage target files on the machine hosting the Integration Service or write to the target files on the FTP or SFTP host.
You can stage an FTP or SFTP file to eliminate the risk of partial transfers due to network failure. Create staged files on the machine that hosts the Integration Service. The Integration Service starts the read operation after the FTP or SFTP process creates the staged file. When you use FTP or SFTP at the target, the FTP or SFTP process starts after the Integration Service writes the staged file. If the network fails before the staged file is complete, you can delete the staged file and run the session again.
You can configure staging in the FTP or SFTP connection object or through pre- or post-session shell commands.