O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Variables, Expressions, and Dynamism in SSIS

by Reza Rad and Pedro Perfeito

In this chapter, we will cover the following topics:

  • Variables and data types
  • Using expressions in Control Flow
  • Using expressions in Data Flow
  • The Expression Task
  • Dynamic connection managers
  • Dynamic data transfer with different data structures

Introduction

A package is executable and acts like an application. One of the basic requirements in every application is to work with variables. SSIS has the following two types of variables:

  • System variables: System variables are used to fetch system information at a specific place in a package
  • User variables: User variables can be used to read and write through their scope in the package

Expressions as we have talked about them ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required