Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Using psftp.exe to copy files Expand / Collapse
Author
Message
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: 2 days ago @ 11:21 AM
Points: 361, Visits: 1,174
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
bye


A bat file that contains the following:
C:\Program Files\PSFTP\psftp.exe open user@server.name.net -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