November 12, 2014 at 4:08 pm
Hi,
We have a job running the SSIS Package. I am working with that SSIS Package. The SSIS package has a script task. In the script task they used the variable of source path. I want to change the value of that variable (Need to modify the source path).
I modified the variable value in that package and in the config file but getting error message
Exception has been thrown by the target of an invocation.
Any help!
November 13, 2014 at 2:05 am
Hi ,
When you are getting error, during execute phase or validation phase.
If it is during validation then make sure the source path which you have given is correct in both the places ( Script task and config file ).
-Aravind
November 17, 2014 at 4:05 pm
Hi,
Actually we create a Sql Job on scheduled basis to run that SSIS Package everyday.
The job is failing and just giving the script task where it failed but not giving further information. When I changed the variable name in Config file, it is showing the new values in config file but when I run the package still it is not taking the new values. I am not sure why it is happening like this.
So I added the existing .dtsx file into the new project and then changed the variable value and save the changes then replace the old package with the new package but still it is not taking the new variable. When I opened that package it is not updated the new value in that package.
So in the job I set the value like take the new variable value but still it is not taking the new value?
When we run the package individually through dtexecuteutility or through job it has to take the config file we mentioned but it is not taking.
Do you have any solution to solve this issue?
Thanks for the help
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply