unable to assign updated value to ssis variable using script task

Question

I created some variables and using the C# script task I am trying to modifying the values of the variables. initial values

Expression Builder image for pine variable

FolderInputPath="D:\"; Pine="C:\abc\qwr";

please find the variable status

the above values were set at the variables in ssis package

string filename = "";
string newname="";
filename = Dts.Variables["User::FolderInputPath"].Value.ToString();

if (filename.Substring(filename.Length - 1, 1) != "\\")
{
    filename = filename + "\\";
}

newname = filename + "Pine.txt";
Dts.Variables["User::Pine"].Value = newname;
MessageBox.Show(newname + "     before value is " + Dts.Variables["User::Pine"].Value.ToString());

As per the above logic we User::Pine should have the value "D:\Pine.txt" but when i run the code the value for the variable User::Pinedoesn't change

thanks in advance

Make sure to mark the variables as Read/Write and not just as ReadOnly on the script component. — EzLo
– EzLo, Commented Jan 16, 2019 at 11:31
Check if your variable is set to "Evaluate as expression" on the Properties tab (F4). Undo if so. — EzLo
– EzLo, Commented Jan 16, 2019 at 11:56

EzLo · Accepted Answer · 2019-01-16 12:08:28Z

2

Open the variable pane, click on your variable and press F4 to open the Properties window.

Make sure that "EvaluateAsExpression" and "ReadOnly" are both set to False. Also make sure that the "Expression" field is empty (like the following image). If it's not, select it's text and delete it.

answered Jan 16, 2019 at 12:08

EzLo

14.2k10 gold badges38 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

unable to assign updated value to ssis variable using script task

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related