How to use Package Level Parameter and Project Level Parameters in Script Task in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

Project level and Package level parameters are available in SSIS 2012 and later versions of SSIS. We use them in SSIS Package so we can change the values of these parameters by using SSIS Configuration.

Project Level Parameters are available to all the packages in the project but the scope of Package Level Parameters are limited to the package in which they are created.

In this video we will learn the following Items
How to Create Project Level parameters in SSIS Project
How to create Package Level  Parameters in SSIS Package
How to Select Project Level and Package Level Parameters in Script Task
How to save Project Level and Package Level Parameter values to local variables in Script Task
How to use C# and VB.Net  in Script Task and save the value of Package Level and Project Level Parameters to local variables


How to use Project Level and Package Level Parameters in Script Task with C#

public void Main()
        {

            string ServerName;
            string SourceFolder;
            string PackageLevelParameter;

ServerName = Dts.Variables["$Project::ServerName"].Value.ToString();
SourceFolder = Dts.Variables["$Project::SourceFolder"].Value.ToString();
PackageLevelParameter = Dts.Variables["$Package::PackageLevelParameter"].Value.ToString();
            // TODO: Add your code here

            MessageBox.Show(ServerName + SourceFolder + PackageLevelParameter);
            Dts.TaskResult = (int)ScriptResults.Success;
        }

How to use Project Level and Package Level Parameters in Script Task with VB.Net

Public Sub Main()
        Dim ServerName As String
        Dim SourceFolder As String
        Dim PkgLevel As String

        ServerName = Dts.Variables("$Project::ServerName").Value.ToString()
        SourceFolder = Dts.Variables("$Project::SourceFolder").Value.ToString()
        PkgLevel = Dts.Variables("$Package::PackageLevelParameter").Value.ToString()

        MessageBox.Show(ServerName + SourceFolder + PkgLevel)
        ' Add your code here
        '
        Dts.TaskResult = ScriptResults.Success
    End Sub

Package Level Parameter and Project Level Parameter in Script Task in SSIS Package

    Related Posts/Videos on Script Task    

• Script Task - How to use Variables in Script Task by using C# or VB NET Scripting Language
• Script Task - How to Run Stored Procedure in Script Task in SSIS Package and log FTP Folder Names to SQL Server Table
• How to display variable value from Script Task in SSIS Package
• How to use ReadOnlyVariables and ReadWriteVariables feature in Script Task
• How to Delete Top N Rows from Flat File Source