Connecting to sftp port 22 from an ftp task

[mbeth6]

Does anyone know if it is possible to connect to an sftp site using port 22 using SQL2005 SSIS? I am trying to build a package that will go out to the secured ftp site, save it to a local folder and do a bulk insert. So far all attempts have failed.

Thank you in advance for your help.

Mary Beth

 

[mrdenny]

The FTP task doesn't support secure FTP. You'll need to download a third party FTP client then call that app as part of a command shell object.

You might be able to write a Script task which uses .NET to go out and get the file. I don't have any sample code however.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[mbeth6]

Thank you for the information. I will follow up on your suggestion.

Sorry about the cross post. I am still fairly new at these threads and did realize until later that I had done that.

 

[mrdenny]

Not a problem, it happens. We just try to limit it so that it's easier to find the information that you are looking for.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog