June 14, 2012 at 3:30 am
Hi,
I have 3 doubts :-
1) If I have a SSIS package with encrypted package protection level and in data flow tasks, there is transformation task
The values are being changed in tht step and if htere is a trigger on it and the pacakge is trying to change the value
What will happen?
2) Can we change the connection string while the package is running?
3) I have 2 oledb source in the connection manager and 1 destination...The packge is deployed and we cant change it.
We want to get data from 3 sources now.... widout touching the package. how to do ??
I can't find on google.
Let me know
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
June 14, 2012 at 3:55 pm
SKYBVI (6/14/2012)
Hi,I have 3 doubts :-
1) If I have a SSIS package with encrypted package protection level and in data flow tasks, there is transformation task
The values are being changed in tht step and if htere is a trigger on it and the pacakge is trying to change the value
What will happen?
It will change the value, but keep in mind the value in the package will ALWAYS return to the original value on subsequent runs, this is true whether the package is encrypted or not.
2) Can we change the connection string while the package is running?
I believe so, there are a couple options, if the SSIS package is run from a job you can update the connection string there, or if you run it from the command line you can pass a modified connection string in there.
3) I have 2 oledb source in the connection manager and 1 destination...The packge is deployed and we cant change it.
We want to get data from 3 sources now.... widout touching the package. how to do ??
You can't change the metadata or add or remove something without a package change.
CEWII
June 15, 2012 at 4:00 am
Elliott Whitlow (6/14/2012)
SKYBVI (6/14/2012)
Hi,I have 3 doubts :-
1) If I have a SSIS package with encrypted package protection level and in data flow tasks, there is transformation task
The values are being changed in tht step and if htere is a trigger on it and the pacakge is trying to change the value
What will happen?
It will change the value, but keep in mind the value in the package will ALWAYS return to the original value on subsequent runs, this is true whether the package is encrypted or not.
2) Can we change the connection string while the package is running?
I believe so, there are a couple options, if the SSIS package is run from a job you can update the connection string there, or if you run it from the command line you can pass a modified connection string in there.
3) I have 2 oledb source in the connection manager and 1 destination...The packge is deployed and we cant change it.
We want to get data from 3 sources now.... widout touching the package. how to do ??
You can't change the metadata or add or remove something without a package change.
CEWII
Thanks a lot elliott 🙂
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply