Need help with an error scripting for SSIS processing

Advertisement

wendas
Guest

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.

Reply with quote

Advertisement

wendas
Guest

Thanks, but I had read that, and it offered me no help to track the problem..

If I can open the ftp site in the winscp window program, then why would it be reachable there but not in the programs script process???... Must be something I am codeing incorrectly in the script process that makes it unreachable... But.... What ????

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
41,442
Location:
Prague, Czechia

wendas wrote:

If I can open the ftp site in the winscp window program, then why would it be reachable there but not in the programs script process???
You did not mention that before.
Please attach a full log file both from GUI and the script.

To generate log file, enable logging, log in to your server and do the operation and only the operation that causes the error. Submit the log with your post as an attachment. Note that passwords and passphrases not stored in the log. You may want to remove other data you consider sensitive though, such as host names, IP addresses, account names or file names (unless they are relevant to the problem). If you do not want to post the log publicly, you may email it to me. You will find my address (if you log in) in my forum profile. Please include link back to this topic in your email. Also note in this topic that you have emailed the log.

Reply with quote

Advertisement

You can post new topics in this forum