How to Execute SSIS 2012 Packages with Script Components from External Applications?

Executing SSIS 2012 Packages with Script Components from External Applications

When executing an SSIS 2012 package containing script components from an external application using the Microsoft.SqlServer.ManagedDTS v 11.0 assembly, an error message may occur for each script component:

"To run a SSIS package outside of SQL Server Data Tools you must install [Script Component Name] of Integration Services or higher."

This error indicates that the machine executing the application does not have the SQL Server Integration Services Service installed.

To resolve this issue:

Determine if Your Application Requires a Specific Script Component

Check if the package contains any script components that have specific dependencies. If so, you will need to install the appropriate version of the script component.

If the package does not require specific script components, you can skip the next step.

Install the SQL Server Integration Services Service

Install the SQL Server Integration Services Service on the machine where the application will be executed. This service provides the necessary runtime environment for executing SSIS packages.

Additional Considerations

• Ensure that the application configuration file (.config) includes the following settings:

<startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0"/>
    <supportedRuntime version="v2.0.50727"/>
</startup>

• If the package uses custom connection managers, you need to specify the assembly qualifier for the connections in your code:

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);
    }
}

By following these steps, you can successfully execute SSIS 2012 packages with script components from external applications.

The above is the detailed content of How to Execute SSIS 2012 Packages with Script Components from External Applications?. For more information, please follow other related articles on the PHP Chinese website!