Need help with an error scripting for SSIS processing
I am trying to follow a working script for a different client where I pull info (created 2 years back so my memory is foggy of what I did and why I did it.. This time I am sending the data to the ftp: I have got an error from the error long but not quite sure what it is trying to tell me..
below is the information (some data changed to protect) that I hope is enough for someone to point me in the right direction of my blunder..
Connection info: (changed to protect)
Host name: ftp3.something.net
Server type: FTP (Remote port 21)
UserID: ftp3.something.net|AINET\aaaaFTP1
Password: psswd
Batch job
option batch on
option confirm off
#Connect using password
open ftp://myusername:psswd@ftp3.something.net|AINET\aaaaFTP1 :21
#move to correct directory
cd /LEDT/compressed
option transfer binary
#Send file to ftp site
put c:\foldername\LEDT_MAN.zip
close
exit
Error from log
. 2014-04-03 12:51:58.535 Connecting to ftp3.something.net ...
. 2014-04-03 12:51:58.551 The requested name is valid and was found in the database, but it does not have the correct associated data being resolved for.
. 2014-04-03 12:51:58.551 Connection failed.
below is the information (some data changed to protect) that I hope is enough for someone to point me in the right direction of my blunder..
Connection info: (changed to protect)
Host name: ftp3.something.net
Server type: FTP (Remote port 21)
UserID: ftp3.something.net|AINET\aaaaFTP1
Password: psswd
Batch job
option batch on
option confirm off
#Connect using password
open ftp://myusername:psswd@ftp3.something.net|AINET\aaaaFTP1 :21
#move to correct directory
cd /LEDT/compressed
option transfer binary
#Send file to ftp site
put c:\foldername\LEDT_MAN.zip
close
exit
Error from log
. 2014-04-03 12:51:58.535 Connecting to ftp3.something.net ...
. 2014-04-03 12:51:58.551 The requested name is valid and was found in the database, but it does not have the correct associated data being resolved for.
. 2014-04-03 12:51:58.551 Connection failed.