Hi, I wanted to SFTP IN SSIS 2008. How can I do that, please provide your valuable input on this. I do not aware about any scripting language, so if you guys has done that through script. Please share me the script supports to C#. Thanks Sandeep Vaishya

use WinSCP: http://winscp.net/eng/docs/guide_ssishttp://www.rad.pasfu.com

go through the post for multiple options for implement SFTP in SSIS http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/00043b62-d243-427a-8118-3b40e9281050/Cheers, Shailesh

And there are also some third party components for sftp: http://www.cozyroc.com/ssis/sftp-task http://www.nsoftware.com/ssis/tasks/sftp.aspx And an open source component for sftp: http://ssissftp.codeplex.com/ Or you can write your own Script Task code and use C# or VB.net to to some sftp for you: http://www.xoowiki.com/Article/SQL-Server/ssis-acces-sftp-475.aspx Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Take a look at SFTP Task for SSIS in our BizCrypto product.

You can download Ultimate SFTP component for .NET and follow the following topic: http://www.atp-inc.net/how-to-use-the-ultimate-components-in-ssis-package-id_75 that shows how to add the installed DLLs to your your SSIS project and get started. Tutorial blogpost is at http://www.atp-inc.net/ultimate-sftp.net-tutorial-id_45