SSIS - how to access system variables in Script Task

Question

Can anyone please advice how to access/read system variables in Script Component (e.g I want to package name from this variable System::PackageName in Script Component)

Unlike forum sites, we don't use "Thanks", or "Any help appreciated", or signatures on Stack Overflow. See "Should 'Hi', 'thanks,' taglines, and salutations be removed from posts?. — John Saunders
– John Saunders, Commented Oct 25, 2012 at 19:06

milivojeviCH · Accepted Answer · 2012-10-25 10:01:09Z

12

In the Script Task Editor, provide the variable names you want to access (for example System::PackageName) in the ReadOnlyVariables field.

From the script, in the C# example, use this:

public void Main()
    {
        bool fireAgain = true;

        // Read the variable
        String PackageName = (String)Dts.Variables["System::PackageName"].Value;

        // Post the value to progress results
        Dts.Events.FireInformation(3, "Package name:", PackageName, "", 0, ref fireAgain);

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

The results:

Package named Package

answered Oct 25, 2012 at 10:01

milivojeviCH

1,62815 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

SSIS - how to access system variables in Script Task

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related