Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

SSIS Project Parameters Vs SSIS Package Parameters

by suresh

In this example, we are going to show how to create or configure SSIS Project Parameters and SSIS Package Parameters. And also show you the difference between SSIS Project Parameters and Package Parameters

SSIS Project Parameters Vs SSIS Package Parameters

In SSIS, Parameters are of two types: Project Parameters, and Package Parameters

  • Project Parameters are something like Global Parameters. You can access them from any package present in that project.
  • Package Parameters are similar to local variables. You can access them from the package that we created. You can’t access the package parameter in pakage1.dtsx from the pakage2.dtsx

SSIS Project parameters

Here, we will demonstrate the steps involved in create project parameters in SSIS. If you look at the Solution explorer, we have Project.params.

Righ- click on the Project.params and select the View Designer option from the context menu to create the SSIS project parameter.

SSIS Project Parameters Vs SSIS Package Parameters 1

When you click on the View Designer option, the following window will open. You can use this window to see the existing project parameter, or to create new project parameter, or to edit the existing one, or to delete.

SSIS Project Parameters Vs SSIS Package Parameters 2

From the below screenshot, we are creating a new project parameter by clicking the New parameter button.

SSIS Project Parameters Vs SSIS Package Parameters 3

We assigned the name as ProjectMessage, Data Type as string, and value = Hey!! This is SSIS Project parameter.

SSIS Project Parameters Vs SSIS Package Parameters 4

Please click the Save button to save the project parameter.

SSIS Project Parameters Vs SSIS Package Parameters 5

Now, You can use this Project parameter, i.e., ProjectMessage in all the packages present in the SSIS Packages folder.

SSIS Project Parameters Vs SSIS Package Parameters 6

SSIS Package parameters

In this example, we will demonstrate the steps involved in creating package parameters in SSIS. To do so, let me create a new package.

If you observe the below screenshot, for every new package, it has a Parameters tab. You can use this tab to create package level parameters. Please click on this tab to create parameters.

SSIS Project Parameters Vs SSIS Package Parameters 7

The interface for creating package level and project level parameters is the same. Please click on the New parameter button to create new.

SSIS Project Parameters Vs SSIS Package Parameters 8

As you can from the below screenshot, we created a new parameter called PackageMessage of type string, and its value is Hi!! This is a Package message.

SSIS Project Parameters Vs SSIS Package Parameters 9

SSIS Project Parameters Vs SSIS Package Parameters

Here, we use the Script task to display the Message that contains the data from both the Project Parameter and the package parameter. To do so, Drag and drop the Script Task from the SSIS toolbox into the Control Flow region.

SSIS Project Parameters Vs SSIS Package Parameters 10

Double click on the Script task will open the following editor to configure the Script task components. We already explained the Script task configuration steps in our previous article, so please refer to the same.

Here we want to select the already created parameters. So, please click the … (Browse) the button beside the Ready Only Variables property.

SSIS Project Parameters Vs SSIS Package Parameters 11

Here we are selecting both the Project Parameter and package parameter as Read-Only variables.

SSIS Project Parameters Vs SSIS Package Parameters 12

Once you selected the required variable, please click on the Edit Script.. button to write the actual C# or VB Script

SSIS Project Parameters Vs SSIS Package Parameters 13

Here we are using Message Box to display the message in pop up.

C# code we used in the below screenshot is:

// SSIS Project Parameters Vs SSIS Package Parameters Example
string ProjectMessage = Dts.Variables["$Project::ProjectMessage"].Value.ToString();
string PackageMessage = Dts.Variables["$Package::PackageMessage"].Value.ToString();

MessageBox.Show("Message From Project Parameter is:" + 
                        ProjectMessage + Environment.NewLine +
                 Environment.NewLine +
                "Message From Package Parameter is:" + PackageMessage);
SSIS Project Parameters Vs SSIS Package Parameters 14

Click OK to finish configuring the SSIS Project Parameters Vs SSIS Package Parameters package. Let us Run the package

SSIS Project Parameters Vs SSIS Package Parameters 15

Let me open another package within this project. From the below screenshot, you can see this is a package that we create in Execute SQL Task in SSIS Single Rowset article.

SSIS Project Parameters Vs SSIS Package Parameters 16

Let me try to access the parameters that we created earlier from this script task. As you can see from the below screenshot, we can access the Project parameter but not the package parameter.

SSIS Project Parameters Vs SSIS Package Parameters 17

Placed Under: SSIS

  • What is SSIS
  • Install SQL Server Data Tools
  • Learn SSIS in 28 Days
  • Create a SSIS Project
  • Create SSIS Package
  • SSIS Connection Manager
  • OLE DB Connection Manager
  • SSIS ADO Connection Manager
  • ADO.NET Connection Manager
  • SSIS Cache Connection Manager
  • SSIS Excel Connection Manager
  • SSIS File Connection Manager
  • SSIS FTP Connection Manager
  • SSIS SMO Connection Manager
  • Source Assistance in SSIS
  • Flat File Source in SSIS
  • OLE DB Source in SSIS
  • Excel Source in SSIS
  • ADO.NET Source in SSIS
  • SSIS FLAT FILE Destination
  • SSIS OLE DB Destination
  • SSIS ADO.NET Destination
  • SSIS Transformations
  • SSIS Audit Transformation
  • SSIS Aggregate Transformation
  • SSIS Aggregate Advanced Mode
  • SSIS Cache Transformation
  • SSIS Character Map
  • SSIS Conditional Split
  • SSIS Copy Column
  • SSIS Data Conversion
  • SSIS Derived Column
  • SSIS Export Column
  • SSIS Fuzzy Grouping
  • SSIS Fuzzy Lookup
  • SSIS Import Column
  • SSIS Lookup Introduction
  • Lookup – OLE DB Connection
  • SSIS Lookup in Full Cache Mode
  • SSIS Lookup – Case Sensitivity
  • SSIS Merge Transformation
  • SSIS Merge Join Transformation
  • SSIS Merge Join – Left Outer Join
  • SSIS Merge – Right Outer Join
  • SSIS Merge Join – Full Outer Join
  • SSIS Multicast Transformation
  • SSIS OLEDB Command
  • OLEDB Command – Delete Data
  • OLEDB Command-Update Data
  • SSIS Percentage Sampling
  • SSIS Pivot Transformation 2008
  • SSIS Pivot Transformation
  • SSIS Row Count Transformation
  • SSIS Row Sampling
  • Script Component as Source
  • Script Component as Destination
  • SSIS Script as Transformation
  • SSIS Sort Transformation
  • SSIS SCD Type 0
  • SSIS SCD Type 1
  • SSIS SCD Type 2
  • SSIS Term Lookup
  • SSIS Term Extraction Intro
  • Term Extraction – Extract Nouns
  • SSIS Extract Noun Phrases
  • Extract Nouns & Noun Phrases
  • Term Extraction – Exclusion Tab
  • SSIS Unpivot Transformation
  • SSIS Union All Transformation
  • SSIS For Loop Container
  • SSIS ForEach File Enumerator
  • SSIS ForEach SMO Enumerator
  • SSIS ForEach Variable
  • SSIS Foreach NodeList
  • Foreach ADO.NET Schema Rowset Enumerator
  • SSIS Bulk Insert Task
  • SSIS Data Profiling Task
  • Execute T-SQL Statement Task
  • SSIS Execute SQL Task Intro
  • SSIS Execute SQL Task Example
  • Execute SQL Task- Single Rowset
  • Execute SQL Task – Full Row Set
  • SSIS Execute Package Task
  • Execute Packages in SQL Server
  • Execute Packages in File System
  • SSIS Execute Package Project Reference
  • SSIS File System Task
  • SSIS File System Task- Copy Files
  • File System Task-Copy Directory
  • File System Task – Delete Files
  • File System Task – Delete Folder
  • File System Task -Move Directory
  • SSIS File System Task -Move File
  • File System – Move Multiple files
  • File System Task – Rename File
  • File System Task – Set Attributes
  • SSIS FTP TASK
  • SSIS Create Local Directory
  • SSIS Create Remote Directory
  • SSIS FTP Task Send Files
  • SSIS FTP – Send Multiple Files
  • SSIS FTP Task Delete Local Files
  • FTP TASK Delete Local Directory
  • FTP Task Delete Remote files
  • SSIS Delete Remote Directory
  • SSIS FTP Task Receive Files
  • SSIS FTP Receive Multiple Files
  • SSIS Script Task
  • Transfer SQL Server Objects Task
  • Transfer SQL Table Structures
  • Transfer SQL Tables with Data
  • Transfer SQL Stored Procedures
  • Transfer User Defined Functions
  • Transfer SQL Views in SSIS
  • SSIS Web Service Task
  • SSIS XML Task-Validate XML File
  • Transform XML File using XSLT
  • XML Task-XML files Differences
  • Create SSIS Catalog
  • Package Deployment using BIDS
  • Deploy Package Using SQL
  • Deploy using SQL Server Wizard
  • SSIS Breakpoints
  • SSIS Checkpoints
  • SSIS Error Handling
  • SSIS Event Handlers
  • SSIS Transactions
  • SSIS Logging
  • SSIS Parameters
  • SSIS Package Configuration
  • Configure using SQL Server
  • Config using Registry Entry
  • Conf with Environment Variable
  • SSIS XML Configuration File
  • XML Configuration File Part 2
  • SSIS Package Protection Level
  • SSIS Incremental Load
  • Incremental Load Example 2
  • SSIS Remove Double Quotes

Copyright © 2021ยท All Rights Reserved.
About | Contact | Privacy Policy