From the course: SQL Server Integration Services
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Run a package - SQL Server Tutorial
From the course: SQL Server Integration Services
Run a package
- [Narrator] When building and testing your packages, you'll typically run them from right here inside of Visual Studio. Eventually, you'll want to export the packages to the Integration Services database to be scheduled and executed by SQL Server, and we'll look at that procedure later on in the course. For now though, it's probably a good idea to make sure that our package is working as intended You can run a package immediately either by right clicking on it in the Solution Explorer and choosing Execute Package or if you have it open in the design surface, like I do now, you can come up here to the toolbar and choose the Start button. That'll switch your view over and show you the status of each task. Ours is going to complete pretty quickly, but as each task completes successfully, you'll see the green check mark icon up here. Let me scroll down in this window a little bit so that we can see the status of each of our tasks. In fact, I'm going to rearrange the size of these windows…
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.