Intro to Using Variables in SQL Server Integration Services

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 useso System Variableso 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

Canal: Howto & Style
Añadido: November 30, 1999 at 12:00 am
Autor: LearnSqlServerDotCom

Duración: 09:27
Puntuación: 4.20
Reproducciones: 4089

Etiquetas: integration  server  services  sql  ssis  

Comentarios