Рет қаралды 10,287
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
Link to the blog post for this video
sqlage.blogspot...
Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers
www.techbrother...