March 22, 2005 at 2:59 pm
Hey guys! I have to do SFTP through a DTS package….
SQL has a task for FTP but not for SFTP ….I am thinking of writing a sftp script which will be called by DTS
If I do this…then I will need SFTP client to be installed on a sql server…..Is that correct???
If it is; then is it safe to install sftp client on a active- passive sql cluster server….i will probably have to do it on all the nodes of the cluster (on the local drives of the node - not the shared drive).
Any suggestions…
March 23, 2005 at 6:59 am
You can script SFTP for MSSQL. You will need an SFTP utility installed on both nodes of your cluster, and they will need to be configured identically.
We had fits trying to get SecureShell's SFTP command line utility to work - all sorts of issues with the certificate for the account attempting to connect. Some days it worked, some days it did not - I figured my prgmrs were not correctly associating the DTS "run as" account with the cert. We ended up using another product (PSFTP, IIRC) which allowed us to send the uid & pwd to the SFTP server. So far, which has worked very well, allowing us to send & receive files from our UNIX-based systems behind a firewall.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply