unable to connect to windows server from DataStage Unix Ser

chrisjones · Post by **chrisjones** » Wed Mar 07, 2012 10:17 am

Hi ,
Can someone suggest how to connect to windows server from DataStage Unix Server and transfer files.

Note: i don't want to use the ftp' stage

Windows server team placed the DataStage Unix Server PUB Key but when i ran the below script it is still asking the password, it not doing the auto logic

#!/usr/bin/ksh
cd /local/apps/OutputFiles/PSC/
ftp -nvi us1003000.corpnet1.com <<EOF
user RR_CDC_US
cd /Home/RD_USER/Inbound
ascii
mput *.txt
echo "Files Transfered Successfully"
bye
EOF

chulett · Post by **chulett** » Wed Mar 07, 2012 12:35 pm

Don't you need to switch to sftp for that?

chrisjones · Post by **chrisjones** » Wed Mar 07, 2012 12:50 pm

i tried sftp option also with below code but still prompting for password..

#!/usr/bin/ksh
cd /local/apps/OutputFiles/PSC/
sftp RR_CDC_US @us1003000.corpnet1.com <<EOF
ascii
mput *.txt
bye
EOF

chulett · Post by **chulett** » Wed Mar 07, 2012 1:07 pm

To me that would imply that the RSA keys weren't setup properly.

atul9806 · Post by **atul9806** » Sun Mar 18, 2012 2:37 pm

Hi
you can try this code :

Code: Select all

#!/usr/bin/ksh 
cd /local/apps/OutputFiles/PSC/ 
ftp -nvi us1003000.corpnet1.com <<EOF 
user USERNAME PASSWORD
cd /Home/RD_USER/Inbound 
ascii 
mput *.txt 
echo "Files Transfered Successfully" 
bye 
EOF

qt_ky · Post by **qt_ky** » Mon Mar 19, 2012 8:22 am

Have you tried setting up a .netrc file?

DSXchange