Intro to Using Variables in SQL Server Integration Services

Visit LearnItFirst, our new channel with over 100 videos!

--------------------------------------------------------------------------------­-

Variables are a very flexible addition to the SQL Services Integration Services package that store values for passing data from Task A to Task B. In this essential introduction to the world of variables in SSIS, Scott will show you how to get started using variables in Integration Services, both directly and indirectly within certain tasks like the script task or the Execute SQL, as well as show you the many things in SSIS they actually can do. Many find that variables are a worthwhile subject for enhancing your SSIS knowledge and this video series will help you to do just that!

Highlights from this video:
• About the two types of variables and their uses
o System Variables
o User-defined Variables
• Adding new variables and setting their credentials (Name, Scope, Data Type, etc)
• Namespace differentiations between system variables and user variables
• Technicalities of names and namespaces

Category:

Howto & Style

Tags:

• ssis
• sql
• server
• integration
• services