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
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 ...