SFTP Task sql 2014 in SSDT

Question

SFTP Task sql 2014 in SSDT

dallas13

SSCertifiable

Points: 7491
More actions
September 22, 2015 at 9:59 pm

#399073

Hello,
I am trying to run ssis package on sql 2014 which has SFTP task but it gives me below error.
Description: Cannot create a task from XML for task "SFTP Task", type "SSISSFTPTask120.SSIS.SSISSFTTask, SSISSFTPTask120, Version=3.0.0.0, Culture=neutral, PublicKeyToken=ad434584aa4b647a123df" due to error 0x80070057 "The parameter is incorrect.".
How to resolve this?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 1

dallas13 (9/22/2015)
Hello,
I am trying to run ssis package on sql 2014 which has SFTP task but it gives me below error.
Description: Cannot create a task from XML for task "SFTP Task", type "SSISSFTPTask120.SSIS.SSISSFTTask, SSISSFTPTask120, Version=3.0.0.0, Culture=neutral, PublicKeyToken=ad434584aa4b647a123df" due to error 0x80070057 "The parameter is incorrect.".
How to resolve this?

Please provide more information, you have been around here long enough to know that we cannot see or know anything more than what is posted.

😎

This error, 0x80070057, is fairly generic (package validation error), my guess would be a missing or wrong parameter.

dallas13 SSCertifiable Points: 7491 More actions · Answer 2

Here is further error description:- Description: Failed to load task "SFTP Task", type "". The contact information for this task is "cosmin.vlasiu@gmail.com".

When I right click SSIS package and run it it works fine.

But I am using dtexec utility in sql 2014 to run this package and its giving me these errors.

The Package is located in 64 bit directory at C:\Program Files\Microsoft SQL Server\DTS\Packages\Package.dtsx

To run below code i need to bring package in msdb database as well which I did.

Here is my cmd,

DECLARE @sqlquery AS VARCHAR(2000)

DECLARE @ServerName VARCHAR(200) = 'XYZ'

SET @sqlquery = 'DTExec /SQL ^"\Package^" '

SET @sqlquery = @sqlquery + ' /SET \Package.Variables[ServerName].Value;^"'+ @ServerName + '^"'

EXEC master..xp_cmdshell @sqlquery

Mike Brown-473607 Valued Member Points: 55 More actions · Answer 3

Mike Brown-473607

Valued Member

Points: 55

January 13, 2016 at 12:32 pm

#1851700

Any luck with this issue?

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 4

Is this a third-party SFTP Task you downloaded and are using in your SSIS Package? Are you saying it works locally running in Visual Studio but not when hosted on a SQL 2014 server?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

dallas13 SSCertifiable Points: 7491 More actions · Answer 5

We are successfully using this task.

We have downloaded it from here, http://ssissftp.codeplex.com/

And then read below documentation on how to register dlls to use it inside package.

http://ssissftp.codeplex.com/documentation

This is working for us fine in 2012 and above environments.