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