Home Forums Data Warehousing Integration Services SSIS 2008 package not running the right configuration file in the SQL Agent Job RE: SSIS 2008 package not running the right configuration file in the SQL Agent Job

  • October 15, 2014 at 1:21 pm

    #1752673

    ranimsql (10/15/2014)

    Hi,

    I have the same problem.. when I moved the package from my local to Test server and specified the job to look at the XML configuration it is still try to connect to the connections that are locally mentioned in the package.

    I am stuck here... I even removed the configurations from my package as mentioned earlier and depending on the xml config that is mentioned in SQL server job my job fails.

    Can you please help me.

    Check the log and see if there are any configuration warnings.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP