From the course: SQL Server Integration Services
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Work with variables and scope - SQL Server Tutorial
From the course: SQL Server Integration Services
Work with variables and scope
- [Instructor] We've seen a number of places throughout the interface that gives us the opportunity to incorporate variables into our control and data flows. Variables allow you to set up the structure of your package with supply-specific values that define execution parameters at runtime. This is useful for creating flexible packages that can be tweaked on the fly, without having to come back into the designer to reconfigure them. I've created a new empty project and we're starting off with a fresh package again. To work with variables you can right-click anywhere on an empty area of the design surface and choose Variables from the popup menu. That will open up a new window at the bottom of the screen. At the time of this recording, there is a known bug with the rendering of the Variables window. If you notice any issues, you can open up the Tools menu and choose Options, then navigate to Environment, General, and uncheck the option for optimize rendering for screens with different…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.