Why Do I Get \"SSIS.Pipeline: To run a SSIS package outside of SQL Server Data Tools you must install [Script Component Name] of Integration Services or higher\" When Executing an SSIS 2012

Executing an SSIS 2012 Package with Script Components from External Application

When attempting to execute an SSIS 2012 package from an external application using the Microsoft.SqlServer.ManagedDTS v 11.0 assembly, you may encounter the error message:

SSIS.Pipeline: 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 SQL Server Integration Services Service is not installed on the machine hosting the external application.

Cause:

The script components in the SSIS package require the Integration Services runtime to execute. When running the package from SSDT, the runtime is automatically available, but this is not the case when executing from an external application.

Solution:

To resolve this issue, install the SQL Server Integration Services Service on the machine where the external application will run.

Additional Tips:

• Refer to this discussion on dba.stackexchange.com for more insights: https://dba.stackexchange.com/questions/49786/error-to-run-a-ssis-package-outside-of-sql-server-data-tools-you-must-install
• Ensure that the external application is running under the correct privileges to access the Integration Services runtime.
• Review the package configuration and verify that any required connection managers are properly set up with the correct qualifiers, as illustrated in the code snippet provided in the question.

The above is the detailed content of Why Do I Get \"SSIS.Pipeline: To run a SSIS package outside of SQL Server Data Tools you must install [Script Component Name] of Integration Services or higher\" When Executing an SSIS 2012. For more information, please follow other related articles on the PHP Chinese website!