This project is read-only.
1

Closed

SFTP task fails once deployed

description

I am using the SFTP SSIS task in both Visual Studio 2010 and 2012. I can successfully execute a package with the SFTP task when debugging from Visual Studio. When I deploy the package to our SSIS server running Windows Server 2008 / SQL Sever 2012 (11.0.2100) I am presented with this error during validation:
Balance File Package:Error: The package cannot execute because it contains tasks that failed to load.
SFTP Task:Error: There were errors during task validation
SFTP Task:Error: The task has failed to load. The contact information for this task is "".
SFTP Task:Error: Failed to load task "SFTP Task", type "". The contact information for this task is "".
Balance File Package:Error: Cannot create a task from XML for task "SFTP Task", type "SSIS.Extensions.SFTPTask.SFTPTask, SSIS.Extensions.2012, Version=2.0.1.2, Culture=neutral, PublicKeyToken=be2dd18b41995f85" due to error 0x80070057 "The parameter is incorrect."
Any idea what might be wrong?
Closed May 14, 2014 at 8:17 PM by mcpunjabi

comments

tvanstone wrote Mar 17, 2014 at 2:02 AM

Kindly disregard - I discovered this post: https://ssisextensions.codeplex.com/discussions/444401 instructing me to install the MSI package on the server as well.

Thanks for a fantastic plugin.

wrote May 14, 2014 at 8:17 PM