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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics