SSIS Tutorial Part 128- How to Use Project Level and Package Level Parameters in Script Task

  Рет қаралды 10,287

TechBrothersIT

TechBrothersIT

Күн бұрын

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...

Пікірлер: 3
КОГДА БАТЯ ПОЛУЧИЛ ТРАВМУ НА РАБОТЕ😂#shorts
00:59
New Colour Match Puzzle Challenge With Squid Game 2 - Incredibox Sprunki
00:30
76 What are variables and Parameters in SSIS
10:48
Learn SSIS
Рет қаралды 22 М.
68 Project Deployment in SSIS and Create environment
17:20
Learn SSIS
Рет қаралды 59 М.
CompTIA Network+ Certification Video Course
3:46:51
PowerCert Animated Videos
Рет қаралды 9 МЛН
59 Breakpoints in SSIS | how to use breakpoints in ssis
20:13
Learn SSIS
Рет қаралды 15 М.
86 Project parameters in SSIS | How to use SSIS parameters
9:37
Parameters in SSIS, Use Parameters in Execute SQL Task in SSIS
17:28
Training2SQL MSBI
Рет қаралды 28 М.
109 Event Handlers in SSIS | How to use Event Handlers in SSIS
12:30
SSIS Tutorial - Parameterising Connection Managers
10:53
BeardedDev
Рет қаралды 35 М.
КОГДА БАТЯ ПОЛУЧИЛ ТРАВМУ НА РАБОТЕ😂#shorts
00:59