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 ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
