Microsoft SSIS DTS Package Action Pack

Executing published Microsoft SQL Data Transformation Services (DTS) Packages

MS SQL Server Integration Services support two deployment models: 1) The project deployment model and 2) The legacy package deployment model, i.e. Data Transformation Services (DTS).

This Action Pack is intended to execute legacy SSIS Packages.

Please note that SSIS usually only accepts requests from Windows users who use Windows Authentication. Please make sure that the SQL Agent is configured accordingly.

The Action Pack requires:

  • CA Automic One Automation Platform V12.1.1 minimum
  • A Windows OS Agent
  • "dtexec" Utility

See the following page for further information on the "dtexec" command: https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility

Action

  • Execute DTS Package

Screenshots

Created by....

Henrik Westrell


Email:
henrik.westrell@automic.com


Login to View or Leave Comments