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!     

About the Instructor: