Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Run SSIS package deployed in Integration Service Catalog (SSISDB) as a SQL Agent Job based on a XML Configuration File

Unanswered 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
     
     
    Sign In to Vote
    0

    Hi,

    I am using SQL Server 2012 (SSIS). In Project Deployment Model is there a way to run the package deployed in SSIS Catalog as a SQL Agent Job based on XML Configuration file.

    Thanks,

    Rehan

     

All Replies

  • Saturday, January 26, 2013 10:52 AM
    Moderator
     
     
    Sign In to Vote
    0

    yes, go to the properties of the control flow (/package) and search for Configurations (but haven't tested it yet):

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter




     
  • Sunday, January 27, 2013 4:26 AM
     
     
    Sign In to Vote
    0

    Thanks SSISJoost,

    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.

    thanks,

    Rehan

     
  • Sunday, January 27, 2013 1:00 PM
    Moderator
     
     
    Sign In to Vote
    0

    Have you added the XML config, recreated the ISPAC and deployed it to the SSISDB?

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

     
  • Sunday, January 27, 2013 3:38 PM
     
     
    Sign In to Vote
    0

    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.