O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

Deploying SSIS Packages

When you've completed implementing your SSIS package (or packages) in BIDS, you'll next want to deploy the package to a testing and, eventually, into a production environment. To start this process, you must first validate the SSIS packages you've created in BIDS by working with the SSIS project menu. When you right-click the SSIS project name in the Solution Explorer, the options available are Build and Rebuild. What exactly do these options do?

First, you need to understand what exactly you are creating in the SSIS designer. Although you are working visually, you are creating an executable file. The code that you are writing when you create an SSIS package is a dialect of XML. If you want to view this XML, right-click ...

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