O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Variables

Although we’ve mentioned variables several times in this chapter, we haven’t yet considered them closely. In this section, we examine variables in the context of Integration Services. Like any other software development platform, Integration Services supports variables as a mechanism for storing and sharing information. For developers coming from a traditional programming language such as Microsoft Visual Basic or Visual C#, or for those who are experienced with database programming in a language such as Transact-SQL, variables in SSIS might seem a little strange, mostly because of the differences in the SSIS platform itself. To declare variables in SSIS, you use the Variables window found in the visual designers.

Variables Window

To open ...

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