Why Do I Get \'SSIS.Pipeline: To run a SSIS package outside...\' Error when Executing SSIS 2012 Packages with Script Components?

Executing SSIS 2012 Packages with Script Components from External Applications

Background:

Developing an application that executes SSIS 2012 packages using the Microsoft.SqlServer.ManagedDTS v 11.0 assembly can be a valuable task. However, encountering errors related to missing script components when executing packages designed in SSDT-2012 can be frustrating.

Issue:

When attempting to execute an SSIS 2012 package containing script components from an external application, the following error message occurs for each script component:

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

Cause:

This error indicates that the SQL Server Integration Services Service is not installed on the machine where the application is running. The Integration Services Service is required to provide the supporting infrastructure for script components during package execution.

Solution:

To resolve this issue, install the SQL Server Integration Services Service on the machine where the application will be executed. It's important to note that the Integration Services runtime files and script components must be installed on the same machine.

Additional Notes:

• Refer to the Microsoft documentation at https://docs.microsoft.com/en-us/sql/integration-services/install-sql-server-integration-services
  for specific instructions on installing Integration Services.

• If the issue persists after installing the Integration Services Service, try verifying the following:

  • The app.config file has the correct assembly version specified (e.g., )
  • The script components are properly registered in the Assembly Cache by ensuring that the assembly containing the components is accessible to the application
• See the related discussion on DBA.StackExchange at https://dba.stackexchange.com/questions/49786/error-to-run-a-ssis-package-outside-of-sql-server-data-tools-you-must-install for additional insights.

The above is the detailed content of Why Do I Get \'SSIS.Pipeline: To run a SSIS package outside...\' Error when Executing SSIS 2012 Packages with Script Components?. For more information, please follow other related articles on the PHP Chinese website!