Calling an SSIS Package (with SSIS Extensions) from a SQL Server Job

Sep 9, 2013 at 3:15 PM
First of all, thank you for a very useful set of extensions. I appreciate your work on this.

I have several SQL jobs calling SSIS packages that are running successfully already. I created a new package to perform a data extract to a CSV file stored on the file system and used the SFTP task to transfer the file. The package runs successfully on my laptop.

However, it does not work when called from a SQL job. My assumption is that I need to do something on the SQL server itself, so that it recognizes the SFTP script task. This is probably an SSIS 101 kind of issue, but I'm just not sure what needs to be done.

Would anyone here be willing to help me out with this step?

Thank you in advance!

Bill

Version Details:

Laptop: Visual Studio/BIDS 2008, Windows 7, 64-bit
Server: SQL Server 2008R2, 64-bit

Error Message:

Executed as user: <removed>. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 5:26:00 PM Error: 2013-09-06 17:26:00.86 Code: 0xC0010018 Source: SFTP Task Description: Failed to load task "SFTP Task", type "SSIS.Extensions.SFTPTask.SFTPTask, SSIS.Extensions.2008R2, Version=2.0.0.8, Culture=neutral, PublicKeyToken=be2dd18b41995f85". The contact information for this task is "". End Error Error: 2013-09-06 17:26:00.88 Code: 0xC0010018 Source: SFTP Task 1 Description: Failed to load task "SFTP Task 1", type "SSIS.Extensions.SFTPTask.SFTPTask, SSIS.Extensions.2008R2, Version=2.0.0.8, Culture=neutral, PublicKeyToken=be2dd18b41995f85". The contact information for this task is "". End Error Error: 2013-09-06 17:26:13.01 Code: 0xC0010026 Source: SFTP Task Description: The task has failed to load. The contact information for this task is "". End Error Error: 2013-09-06 17:26:13.01 Code: 0xC0024107 Source: SFTP Task Description: There were errors during task validation. End Error Error: 2013-09-06 17:26:13.01 Code: 0xC0010025 Source: AIMN Inform Data Export Description: The package cannot execute because it contains tasks that failed to load. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:26:00 PM Finished: 5:26:13 PM Elapsed: 12.589 seconds. The package execution failed. The step failed.
Sep 10, 2013 at 4:40 PM
I realize that my initial question may inspire a RTFM response, but please bear with me. Is it possible that I just need to run the installer on the SQL Server on which I want to deploy the package? I ran it on my own machine where the package runs fine.

Again, I assume I need to something on the server itself. Is it simply running the installer there?
Sep 13, 2013 at 3:38 PM
From looking at the FM, they say that the required DLL's are copied into the GAC and the SQl server installation folder. This means that unless you install it on the server, your package will not work.
Sep 16, 2013 at 2:52 PM
Thanks for the response, Jason!
Feb 27, 2014 at 1:07 PM
Please be sure to install ssis extensions (using the setup installer) on the server.