How to Run SSIS Packages with Script Components from External Applications?

Executing SSIS 2012 Package with Script Components from External Application

In an attempt to automate SSIS package execution, developers often utilize external applications to invoke these packages. However, when the target package resides outside of SSIS Data Tools (SSDT) and includes script components, an error message may surface:

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 arises because the external application lacks the necessary dependency on the SQL Server Integration Services (SSIS) Service for the smooth execution of script components.

Resolving the Issue

To resolve this issue, ensure that the machine hosting the application executing the SSIS package has the SQL Server Integration Services Service installed. This service provides the runtime environment required for script components to function properly.

Important Note:

It's important to refer to the linked URL (https://dba.stackexchange.com/questions/49786/error-to-run-a-ssis-package-outside-of-sql-server-data-tools-you-must-install) for additional insights and potential alternative solutions.

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