SSIS – Automate a Package in Development
In development, I have no ways to automate a SSIS package via AutoSys.
Here are some simple steps I take to automate execution of a SSIS package.
1) Import the package into SQL Integration Services.
2) Create a job to execute the package.
3) In the Data sources tab, check the appropriate data source(s) that need explicit login credentials, and enter appropriate user id and password (batch login IDs are the best).