Run SSIS package deployed in Integration Service Catalog (SSISDB) as a SQL Agent Job based on a XML Configuration File
Saturday, January 26, 2013 6:57 AM
Saturday, January 26, 2013 10:52 AMModerator
yes, go to the properties of the control flow (/package) and search for Configurations (but haven't tested it yet):
- Edited by SSISJoostMicrosoft Community Contributor, Moderator Saturday, January 26, 2013 10:56 AM
Sunday, January 27, 2013 4:26 AM
Yes we can run the package in BIDS using the configuration file. But this i not the answer. The package in deployed in SSISDB Catalog using .ISPAC file and I want to run the package from a SQL Agent Job using a XML configuration file.
Sunday, January 27, 2013 1:00 PMModerator
Sunday, January 27, 2013 3:38 PM
Yes I have enabled configuration in the package and then deployed it to SSIS Catalog and creating the ISPAC in the process. Then I created a SQL Agent Job and configured it to run the package deployed in SSIS Catalog. I picked up only the Connection Info from what was in the configuration file and populated it in the Connection Managers tab under Configuration tab. Although the configuration Manages did not show the values of other Variables in the config file but when I ran the job and it ran fine. This is all good.
But now i want to run this job against a different server and with different variable configuration. Do i need to redeploy after changing the configuration file attached to the package? How can I run the job with different configuration without redeploying? Preferably using a config file.
- Edited by Rehan Mahmood Monday, January 28, 2013 1:11 AM