SSIS Script task 'ReadOnlyVariables'
My Control Flow includes a script task.
I have inserted my variable names into the 'ReadOnlyVariables' textbox.
My script is writing to the variables and it all seems to work.
Can I believe my eyes or is the title 'ReadOnlyVariables' deceiving.
An example of my script is:
Dts.Variables(
"LanguageID").Value = 87
Mr Shaw
January 20th, 2011 9:16am
if you want to set a value into package variable(as in your case ) , you should set it as
ReadWriteVariables
ReadOnlyVariables is only for reading value.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 9:19am
Are you sure the code where you are assigning values to the read only variable is reached while execution? Are you not seeing any errors?
January 20th, 2011 9:24am
I think I have the same issue as:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c823a993-7b48-49be-8513-3085655ba91f/
Even though it is working I am going to change it ReadWriteVariables.Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 9:30am
Yes, it appears to be a bug. But its is a subtle in nature defect, so to say. How does it affect your solution?
Anyway, if you feel important, you may vote for it at this MS Connect article
https://connect.microsoft.com/SQLServer/feedback/details/369187/ssis-script-task-passed-in-read-only-variable-is-updateable?wa=wsignin1.0Arthur My Blog
January 20th, 2011 10:05am