Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Videos · SQL Programming Video Training
   
SQL Server Integration Services Training Videos
Integration Services Videos in Series Home  Subscriber Videos  

Using Variable in SSIS Tasks and Containers - A How-To Guide (Video Series)

Video Image 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:

TitleSkillLengthDownload
Part1-An Introduction to Using Variables in SQL Server Integration Services    Free SQL Server Integration Services Training Video 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


Other Websites We Offer
LearnReportingServices.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
12/5/2008 1:38:15 AM