Parameter in SSIS allows you to assign the values to a project or package at the run time.
There are the two types of parameter available in SSIS:
1) Project Parameter
2) Package parameter
You can access project parameters from any package which exist in project.
Here, We are explaining steps to create Project Parameters in SSIS.
Step 1 : Open Solution Explorer of project .
Step 2 : Double click on Project.params, View Designer window will be open.
Step 3: Now We can create Parameter by clicking Add Parameter Button.
Step 4: We can assign the Name as “SampleMessage”, Data type as “String” , Value as “This is the Project Parameter”for parameter.
Step 5 : Click on save button to save the parameter.
Step 6 : Now we can access this parameter in all packages for this project.
You can access package parameters from single package only that we created.
Here, We are explaining steps to create Package Parameters in SSIS.
Step 1 : Click on Parameter tab, View Designer window will be open.
Step 2: Now We can create Parameter by clicking Add Parameter Button.
Step 3: We can assign the Name as “SampleMessage”, Data type as “String” , Value as “This is the Package Parameter”for parameter.
Step 4 : Click on close button to save the parameter.
Step 5 : Now we can access this parameter in single package only that we created.
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.