Want to FTP the zip file using SSIS
Hi, I am using SSIS and have some zip file at some location on my local computer which I want to FTP to some FTP location. Can anyone suggest simple approach for this. Example related link will also be helpful. Thanks
January 21st, 2012 1:18am

You can use the FTP task for this. Hope the below link helps with the details of the task http://www.techbubbles.com/sql-server/using-file-system-task-and-ftp-task-in-sql-server-ssis/ http://msdn.microsoft.com/en-us/library/ms137656.aspx
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2012 1:31am

Hi UltraDev, I have written a blog specifically for this issue (Send file(s) to FTP server) URL: http://www.sqlservergeeks.com/blogs/raunak.jhawar/sql-server-bi/398/sql-server-2012-ssis-sending-files-using-ftp-task Please vote as helpful or mark as answer, if it helps
January 21st, 2012 1:51am

Hi Raunak, I am getting [FTP Task] Error: Unable to connect to FTP server using "CSVFTPConn". Where "CSVFTPConn" is my FTP connection name in which I have provided all credentials required correctly and Test Connection also succeeds. But the task fails at run time. What could be the reason ? Thanks
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2012 2:03am

Hi UltraDev, How are you executing the package. If using a SQL Server Agent, see this http://support.microsoft.com/kb/918760Please vote as helpful or mark as answer, if it helps
January 21st, 2012 2:09am

I am executing the package in development itself i.e. from package only using right click --> Execute Task
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2012 2:46am

Got it. Step 1: Create the FTP connection manager using the FTP task Step 2: Supply necessary credentials Step 3: Do not open the FTP connection manager editor again, as it will delete the password(empty the password ans replace it with empty string) Please vote as helpful or mark as answer, if it helps
January 21st, 2012 3:10am

even if I do it using the approach you said Step 1,2,3....still it is failing with the same error :)
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2012 3:22am

This is a connection error, as far as I understand. The connection settings are getting modified.Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar
January 21st, 2012 4:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics