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
- Execute DTS Package