Created SSIS Job using SFTP Task. Works fine running maunally. Error message when trying to run as a scheduled job,

SFTP Task SSISSFTTask Description: Error : timeout: socket is not established. Please check your username, password or port End Error

Id #2648 | Release: None | Updated: Oct 4 at 4:31 PM by WarrenTyler | Created: Oct 4 at 4:31 PM by WarrenTyler

SHA-2 Support?

We've been using this product for a few years now. Love it. Looks like the SSH libraries only support SHA-1 and that is getting deprecated quickly. Any work being done to update?

Id #2603 | Release: None | Updated: Oct 12, 2016 at 1:24 PM by ZeroBullChip | Created: Oct 12, 2016 at 1:24 PM by ZeroBullChip

Timeout setting on SFTP Task

Is there a timeout setting on the SFTP task?

Id #2600 | Release: None | Updated: Sep 22, 2016 at 7:05 PM by bkamal | Created: Sep 22, 2016 at 7:05 PM by bkamal

Copies rescusive even though Recursion is set to false

I have implemented the SFTP task in a SSIS package to copy all files in a specific directory. I have defined as the localfile a path and . as the file same. For example \ServerName\data*.* . When I...

Id #2586 | Release: None | Updated: Aug 11, 2016 at 7:15 PM by JetPilotCoder | Created: Aug 11, 2016 at 7:15 PM by JetPilotCoder

Does anyone know how to SHUT UP IT when it loads file list? ;)

I need to write a log on the bunch of tasks in the package. All is great except for this component, who shouts lots of unuseable log data - file list, which consists day-by-day from the same data a...

Id #2583 | Release: None | Updated: Jul 21, 2016 at 1:07 PM by notricky | Created: Jul 21, 2016 at 1:07 PM by notricky

SFTP Task does not appear after following the instructions

I downloaded the dll for SQL Server 2012. Added the dll here. C:\Program Files\Microsoft SQL Server\110\DTS\Tasks I think I ran that GAC Install ok. But when I refresh my SSIS toolbox I don't see ...

Id #2541 | Release: None | Updated: Jul 21, 2016 at 4:48 PM by notricky | Created: Dec 21, 2015 at 7:24 PM by ayidiscap

GET Task Does NOT Fail When No Files Found (using WildCard)

I am doing a Get FIle and using a wilcard in the Remote Path. I.E. /source/data/junk123*.txt The problem is that when NO matching files are found, the step still reports SUCCESS. I would expect ...

Id #2539 | Release: None | Updated: Dec 17, 2015 at 9:19 PM by mmarsten | Created: Dec 17, 2015 at 9:19 PM by mmarsten

Errors while deploying on server

I got SSIS working on my local machine by dropping SSISSFTPTask110.dll, using gacutil.exe to register it and then "playing a lot" to setup. Now I try to deploy on the server and having issues. Its...

Id #2535 | Release: None | Updated: Nov 16, 2016 at 9:15 AM by cosminfr | Created: Dec 1, 2015 at 8:38 PM by talkel2000

Filter function in SFTP on SQL Server 2014

Hey guys :) we upgraded our SQL Server (2008 to 2014) and we are using the SFTP Task. In the old version, we had the possibility to set a filter (using FLEE) to specify which data we want to downl...

Id #2530 | Release: None | Updated: Oct 29, 2015 at 10:34 AM by ChristophKluge | Created: Oct 29, 2015 at 10:34 AM by ChristophKluge

SFTP error System.IO.IOException: Unable to read data from the transport connection

Hi, I have an SFTP server installed and running. Using WinSCP can connect and send files. Through SSIS SFTP Task V2.0.0.30 when I try to connect and send a file, I get the error below. Could anyo...

Id #2521 | Release: None | Updated: Sep 8, 2015 at 2:29 PM by mtkona | Created: Sep 4, 2015 at 3:52 PM by mtkona