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







12 comments:

  1. Replies
    1. A IEEE project is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities.



      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
      Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

      Delete
  2. Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!
    mobile application development training online
    mobile app development course
    mobile application development course
    learn mobile application development
    mobile app development training
    app development training
    mobile application development training
    mobile app development course online
    online mobile application development

    ReplyDelete
  3. thanks for your information really good and very nice web design company in velachery

    ReplyDelete