Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Using psftp.exe to copy files Expand / Collapse
Posted Wednesday, May 26, 2010 10:38 AM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, December 4, 2016 3:14 PM
Points: 365, Visits: 1,272
We just had an upgrade to our unix server which requires sftp. I'm not sure I understand how this product works and have tried to research all over the internet and try different methods for days. Does anyone know how I can transfer files from the sftp server to a windows box to then have it available for our dts packages and ssis packages to get data from? This is what I have so far.

A text flle (test.txt) that contains the following:
cd /folder/subfolder
lcd \\Share\Folder\
get file1.txt
get file2.txt

A bat file that contains the following:
C:\Program Files\PSFTP\psftp.exe open -pw password-b \\Share\Folder\test.txt

I've tried changing the share drive to a mapped drive, as well as only using one file. Any help appreciated!

¤ §unshine ¤
Post #928454
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse