Using Variable in SSIS Tasks and Containers - A How-To Guide - Video Series Video Category: Variables and Expressions - Creating Dynamic SSIS Packages Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 , SQL Server 2008 This video series will help you work through some of your frustrations in SSIS by discussing the many technicalities and pitfalls when working with Variables, a  very flexible addition to the SQL Services Integration Services package that essentially store values for passing data from Task A to Task B. Scott, your qualified instructor, 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 series: About the two types of variables and their uses System Variables User-defined Variables Some annoyances in SSIS with variables Script task editor DTS Script Task Runtime Error AutoSaving script changes Behavioral changes in SSIS from DTS How to address a user variable that is in a different namespace other than user Working with variables that have the same name, but different namespaces Ambiguous references Properly addressing variables Combining the Script Task with the Data Flow Task Embedding SQL command statements inside of a variable Parameter mapping directions Input Output ReturnValue Modifying result sets and their mappings and much more!

Videos in this Series:

Title Skill Length Download Part1-An Introduction to Using Variables in SQL Server Integration Services     200 10 mins. Download Part2-Setting and Getting Variables Using the Script Task and Visual Basic (VSA)   200 12 mins. Download Part3-How Scoping and Namespaces Work With SSIS Variables   200 11 mins. Download Part4-Using Variables in the Data Flow Task, Data Sources, and Destinations   200 9 mins. Download Part5-Using Dynamically Assigned Table/View Names in Your Data Flow Tasks   200 9 mins. Download Part6-Variables and the Execute SQL Task   200 12 mins. Download Part7-A Better Way to Do Input Parameters and Parameter Mapping   200 11 mins. Download Part8-How to Capture Output Parameters and Return Values From Stored Procedures   200 14 mins. Download Part9-Storing Full Result Sets in Variables and Using the Foreach Loop for Itera...   200 7 mins. Download

< Return to list of all videos