SSIS ScriptTask change Value property of Variable

Question

I try to simply change value of SSIS variable doing this code in ScriptTask:

        string path = Dts.Connections["BazyPobrane"].ConnectionString.ToString();
        string[] nameZIParray = Directory.GetFiles(path, "*.ZIP");
        string[] nameRARarray = Directory.GetFiles(path, "*.RAR");

        foreach (string nameZIP in nameZIParray) //search new ZIP
        {
            if (File.GetCreationTime(nameZIP) > DateTime.Now.AddDays(-1))
            {
                Dts.Variables["User::NazwaPliku"].Value = Path.GetFileName(nameZIP);
            }

        }
        foreach (string nameRAR in nameRARarray) //search new RAR
        {
            if (File.GetCreationTime(nameRAR) > DateTime.Now.AddDays(-1))
            {
                Dts.Variables["User::NazwaPliku"].Value = Path.GetFileName(nameRAR);
            }

        }
        Dts.TaskResult = (int)ScriptResults.Success;

After executing ScriptTask it simply don't change the variable Value. Debug mode seems fine. Maybe i miss some component settings? Thx!

Did you add the variable to the ReadWriteVariables of your script task? — Ocaso Protal
– Ocaso Protal, Commented Apr 11, 2012 at 12:31

Geoff · Accepted Answer · 2012-04-11 13:39:40Z

1

Some things to check:

Are you sure the variable isn't changing? If you put a subsequent script task with a MessageBox in place, does it show the correct value?
I don't think you need the variable type, i.e. remove "user::"
Make sure the variable is in the ReadWriteVariables property, as suggested by @OcasoP
What's the scope of the variable? Make sure you don't have two copies at different scopes, or that at least the one you do have is visible from the scope of the script
You could try locking the variable before writing to it (which should be equivalent to (3) above)

Code example for the last point:

IDTSVariables100 variables = null;
this.VariableDispenser.LockOneForWrite("NazwaPliku",ref variables);
variables[0].Value = myValue;
variables.Unlock();

answered Apr 11, 2012 at 13:39

Geoff

8,9181 gold badge45 silver badges52 bronze badges

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

1 Comment

Kubek Over a year ago

first point was most simple and helpful. MessegeBox showed me real Value of Variable! Seems SSIS Variable window don't refresh fast enough and i was suggested by this one and following component error. Thank You all for your help!

Diego · Accepted Answer · 2012-04-11 13:51:18Z

0

debug your script task adding MsgBox(variable_name) and see its value through the execution. Best debugging option :)

answered Apr 11, 2012 at 13:51

Diego

36.5k21 gold badges94 silver badges138 bronze badges

Collectives™ on Stack Overflow

SSIS ScriptTask change Value property of Variable

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related