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

  • I have a XML config file just with one variable,

    <?xml version="1.0"?>

    <DTSConfiguration>

    <DTSConfigurationHeading>

    <DTSConfigurationFileInfo GeneratedBy="WARBABANK\parmeshwari.kumar" GeneratedFromPackageName="TestConfig" GeneratedFromPackageID="{28DFF61A-A509-4404-956D-9B2704C55848}" GeneratedDate="9/23/2013 11:02:21 AM"/>

    </DTSConfigurationHeading>

    <Configuration ConfiguredType="Property" Path="\Package.Variables[User::remotePath].Properties[Value]" ValueType="String">

    <ConfiguredValue>HI Who are you?</ConfiguredValue>

    </Configuration>

    </DTSConfiguration>

    I just added a SSIS with script task that will display messagebox with this value.

    This runs in SSIS as package , but when I run this as job, this gives me "Exception has been thrown by the target of an invocation."

    I had added this file under Configuration tab and executed. But this always gives me this error

    Can you please help me to find this solution asap?

    What package level protection we need to add?

    Do we have to import package or we can use it from FileSystem ? (both way I tried)

    expecting help