Sorry for the lack of clarity in my question. FTPClient01 is the system that needs to invoke the FTP connection to the FTPServer01. But "FTPClient01" doesnt have sql server (or integration services) running on it. Is there any way to execute the SSIS job from SqlServer01, but using FTPClient01 as the intiator? I hope this clarifies my question.

Is there a way to specify a different local server to connect from in a FTP task? To elaborate, SqlServer01 - Is the system which executes the SSIS job (with the FTP task) FTPClient01- Is the local system that i would like to use as the FTP client FTPServer01 - Is the FTP server Is there a way to specify the FTP task to use "FTPClient01" as the client?

Why do you need a local client? A FTP connection is when you connect to your FTP site/server. That server can actually point to another remote path.Arthur My Blog

I didn't experienced this before, but could you check this way: Define a VPN on FTPClient01 and from SqlServer01 connect to this VPN, then I think you can access to FTPServer01 in this way.http://www.rad.pasfu.com

Sorry for the lack of clarity in my question. FTPClient01 is the system that needs to invoke the FTP connection to the FTPServer01. But "FTPClient01" doesnt have sql server (or integration services) running on it. Is there any way to execute the SSIS job from SqlServer01, but using FTPClient01 as the intiator? I hope this clarifies my question. You cannot use the standard FTP Task to accomplish this. What you need is remote execution and a batch file executing on the FTPClient01 machine. The batch file will include FTP commands that you want executed on the FTPServer01 machine. Check this free remote execution tool here .SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Hi nvarchar, It seems you want to move files from FTPServer01 to FTPClient01, right? If so, we can move the files to SQLServer01 from the FTPServer01 first, and then move the files from SQLServer01 to FTPClient01. We can use the File System Task to move files from SQLServer01 to FTPClient01. In this case, we can execute the package from SQLServer01 directly without any more actions. Thanks, Jin ChenJin Chen - MSFT