From the course: SQL Server Integration Services
Join today to access over 24,600 courses taught by industry experts.
Add execution parameters - SQL Server Tutorial
From the course: SQL Server Integration Services
Add execution parameters
- [Instructor] We just created a variable, and now I want to use it in my package. Variables can be used as parameters in a large number of locations throughout integration services. And they help make your packages more dynamic and flexible. For this example, I'm going to add in a data flow task into my control flow diagram, then I'll switch over to the Data Flow tab, and I'll come down and I'll add an OLE DB Source. Then I'll double click it to configure it. First I want to connect to the Wide World Importers data warehouse. I'll click the New button, click New again, then using the Server dropdown menu, I'll choose the server where that database lives, and then using the database dropdown menu, I'll choose the WideWorldImportersDW database. Let's test the connection to make sure it works, good, and say OK to that. Then I'll press OK again, to fill in that connection manager. In the data access mode, here we have a couple of different places where we could use a variable. We can…
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.