Topic "SSIS Was working now getting connection timeout"

Author Message
Andy Jones

Guest


I am creating an SSIS package to download and process files. I installed WinSCP and got the script task working to download the files. Now that I've completed the rest of the package and try to test the whole process the WinSCP script is no longer working. Regardless of the protocol I use I get a connection timeout error. The GUI and command line work without issue. I can even get a standard FTP task to worn in SSIS. Any ideas on what could have broken? I do not have access to the server logs of the system I am trying to contact. I am attaching the session and debug logs.
SessionLog_Forum.txt (37.81 KB) [Download]

Description: (none)

SessionLog_Forum.txt (37.81 KB) [Download]

Description: (none)

Advertisements
Andy Jones

Guest


I accidently attached the session log twice. Here is the debug log.
DebugLog_Forum.txt (95.25 KB) [Download]

Description: (none)

DavidOz

Guest


Andy Jones wrote:
I am creating an SSIS package to download and process files. I installed WinSCP and got the script task working to download the files. Now that I've completed the rest of the package and try to test the whole process the WinSCP script is no longer working. Regardless of the protocol I use I get a connection timeout error. The GUI and command line work without issue. I can even get a standard FTP task to worn in SSIS. Any ideas on what could have broken? I do not have access to the server logs of the system I am trying to contact. I am attaching the session and debug logs.


I believe the Hash changes between FTP and SFTP you may want to see if it is different.

I created SSIS packages that do both getfiles and putfiles as part of multiple steps with no issue. Though I use a script command and C# for my processing.

Good luck,
David.
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 26331
Location: Prague, Czechia
We would need comparable logs from .NET (failing) and scripting (working) without any obfuscation of a hostname/IP address.
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