Page 1 of 1

unable to connect to windows server from DataStage Unix Ser

Posted: Wed Mar 07, 2012 10:17 am
by chrisjones
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

Posted: Wed Mar 07, 2012 12:35 pm
by chulett
Don't you need to switch to sftp for that?

unable to connect to windows server from DataStage Unix Ser

Posted: Wed Mar 07, 2012 12:50 pm
by chrisjones
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

Posted: Wed Mar 07, 2012 1:07 pm
by chulett
To me that would imply that the RSA keys weren't setup properly.

Re: unable to connect to windows server from DataStage Unix

Posted: Sun Mar 18, 2012 2:37 pm
by atul9806
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


Posted: Mon Mar 19, 2012 8:22 am
by qt_ky
Have you tried setting up a .netrc file?