To Reza: Yes I know that, and I only have one vesion on my machine SQL2008R2, can you use the variable in a ScriptComponent? can you test it for me ToPerez : No i am not i want to get the value and save it in a txt file, I just want to read it, and I know that you can not change the value of the system variable because it's be controlled by the package, you only have read rights to that variable Sincerely SH -- MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

I my case I can not use the system::VariableValue in a script component what i did was capture the value before calling the DFT within "OnVariableValueChanged event" in OnVariableValueChanged event i have a script task that captures the System::VariableValues value within a template variable like "uVar_VariableTraceMyVariableValue" , then i have the DFT , and within that i have a Script component that uses "uVar_VariableTraceMyVariableValue" , then i have a FF_DES object to write to the FF I have tried this on different BIDS and with C# within the script component and it did not workSincerely SH -- MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Hi All I want to use the "System::VariableValue" changes in a text file my problem is - when I set "System::VariableValue" in a ScriptComponent and click on "Edit Script" i get the error TITLE: Microsoft Visual Studio ------------------------------ Cannot show Visual Studio Tools for Applications editor. For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2008&ProdVer=9.0.30729.1&EvtSrc=Microsoft.DataTransformationServices.DataFlowUI.SR&EvtID=CouldNotShowVSTAIDE&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: Object reference not set to an instance of an object. (Microsoft.SqlServer.TxScript) What i am doing is tracing the changes in my variablesSincerely SH -- MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Hi Shahriar, for tracing changes in the variable you can use the OnVariableValueChanged event to do everything you want when variable value changed. and about the Script Editor, do you have more than one BIDS in different versions together on same machine?http://www.rad.pasfu.com

Hi NiK, Correct me if I am wrong but are you trying to chenge the value of a "system variable"?Prez