Running SSIS 2012 package with script components from an external application

Question

I am writing an application that will run the SSIS 2012 package using the Microsoft.SqlServer.ManagedDTS v 11.0 build. The package I'm trying to execute was designed and successfully executed from SSDT-2012 and has script components that process strings that are not passed correctly.

When I try to run my application, I get an error message for each of my script components:

SSIS.Pipeline: To run an SSIS package outside of SQL Server Data Tools, you must install [Script Component Name] Integration Services or higher.

Configuration: creating an application for x86 on Windows with the following app.config file:

<?xml version="1.0" encoding="utf-8" ?> <configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0"/> <supportedRuntime version="v2.0.50727"/> </startup> </configuration> 

The only relevant code is:

 using System; using System.Data; using System.Data.Common; using System.IO; using Microsoft.SqlServer.Dts.Runtime; class MyApp { public void ExecutePackage() { //Assume I have all the variables I need like packageFile, packageName, //srcConnectionString, destConnectionString and eventListener etc. Package pkg; Application app; DTSExecResults pkgResults; app = new Application(); pkg = app.LoadPackage(packageFile, eventListener); pkg.Variables["SrcConnectionString"].Value = srcConnectionString; pkg.Variables["DestConnectionString"].Value = destConnectionString; if (null != srcAssembly || null != destAssembly) { foreach (ConnectionManager connection in pkg.Connections) { if (null != srcAssembly && connection.Name.Contains("Source")) { connection.SetQualifier(srcAssembly); } else if (null != destAssembly && connection.Name.Contains("Destination")) { connection.SetQualifier(destAssembly); } } } pkgResults = pkg.Execute(null, null, eventListener, null, null); } } 

Any ideas?

Answer 1

You do not have the SQL Server Integration Services service installed on the computer on which the application is running.

See also https://dba.stackexchange.com/questions/49786/error-to-run-a-ssis-package-outside-of-sql-server-data-tools-you-must-install