Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Connecting via SSH

Author  Topic 

rbohaty
Yak Posting Veteran

71 Posts

Posted - 2005-07-25 : 12:53:21
Is it possible to have a dts package connect via SSH (port 22) to download a file?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-07-25 : 13:38:40
not natively, but you can use some tools (like putty) to accomplish this.



-ec
Go to Top of Page

rbohaty
Yak Posting Veteran

71 Posts

Posted - 2005-07-25 : 14:22:24
Do I call Putty from within the DTS package? If so how do I do that?

Thanx...
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-07-25 : 17:21:46
you can use the execute process task in DTS, point it to PSFTP (from the putty SSH tools) and there you go.



-ec
Go to Top of Page
   

- Advertisement -