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:
A bat file that contains the following:
C:\Program Files\PSFTP\psftp.exe open firstname.lastname@example.org -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 ¤