Topic "Need help with an error scripting for SSIS processing"

Author Message
wendas

Guest


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.
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
Location: Prague, Czechia
Please read documentation:
https://winscp.net/eng/docs/message_name_no_data

If that does not help, come back.
_________________
Martin Prikryl
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 ????
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
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.
_________________
Martin Prikryl
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License