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


  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

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

  3. Here is the details of best BSc Medical Imaging Technology Colleges in Bangalore. You can get the college details from the below link. BSc Medical Imaging Technology Course is one of the best demanding course in recent times in India
    BSc Medical Imaging Technology Colleges In Bangalore

  4. Christian College Bangalore providing BSc Medical Imaging Technology Course. Here is the link about the details of BSc Medical Imaging Technology. You can click the below link for more information about BSc Medical Imaging Technology.
    BSc Cardiac Care Technology Colleges In Bangalore

  5. Christian College Bangalore providing BSc Optometry Course. Here is the link about the details of BSc Optometry. You can click the below link for more information about BSc Optometry. BSc Optometry is one of the most demanding course in recent times.
    Optometry Colleges In Bangalore

  6. GrueBleen is one of the Branding and Marketing agency Based in Riyadh- Saudi Arabia. The main functions of GrueBleen is Advertising, Branding, Marketing, Office Branding, Exhibition Management and Digital Marketing. Visit the below link to know more about GrueBleen Creative Club.
    Branding Agency Riyadh
    Marketing Agency Riyadh

  7. Agriculture Solutions – Taldeen is a plastic manufacturing company in Saudi Arabia. They are manufacturing agricultural plastic products like greenhouse cover and hay cover. Visit the below link to know more details
    Agriculture Solutions
    Greenhouse Cover

  8. BSc Perfusion Technology – If you are looking to study BSc Perfusion Technology in Bangalore, just check out the following link. In that link you can get the details of Best BSc Medical Imaging Technology colleges in Bangalore
    BSc Perfusion Technology Colleges in Bangalore

  9. It is actually a great and helpful piece of information about Java. I am satisfied that you simply shared this helpful information with us. Please stay us informed like this. Thanks for sharing.
    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

  10. Wow i can say that this is another great article as expected of this blog. Thanks a million and please keep up the effective work.
    Visit us for Customised Credit Card Shaped Pen Drive.

  11. here you can get more info about Allama Iqbal open university result data and student ID process, application tracking, BA Admission
    Allama iqbal open university

  12. Hi I am from Join Pak Navy I and I really like your work thanks for this information and keep it up you are doing good.

  13. Case Search online at Sindh High Court can provide you full details about your case at Sind High Court. Check the hearing date online. On Just one click you can find all the details through Case Search Sind High Court.

  14. Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. plant operator agency

  15. It is imperative that we read blog post very carefully. I am already done it and find that this post is really amazing.
    call conferencing software

    South Drop Taxi provides one way drop and round trip outstation taxi service at Best price.Our Service available 24/7 in 300+ Cities of South India