May 26, 2010 at 10:38 am
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 ¤
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply