Creating the Deployment Project
New: 14 April 2006
In Integration Services, the deployable unit is an Integration Services project. Before you can deploy packages, you must create a new Integration Services project and add all the packages and any ancillary files that you want to deploy with the packages to that project.
To create the Integration Services project
Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL ServerBusiness Intelligence Development Studio.
On the File menu, point to New, and then click Project to create a new Integration Services project.
In the New Project dialog box, select Integration Services Project in the Templates pane.
In the Name box, change the default name to Deployment Tutorial. Optionally, clear the Create directory for solution check box.
Accept the default location, or click Browse to locate the folder you want to use.
In the Project Location dialog box, click the folder, and then click Open.
By default, an empty package, named Package.dtsx, is created and added to your project. However, you will not use this package; instead, you will add existing packages to the project. Because all the packages in a project will be included in the deployment, you should delete Package.dtsx. To delete it, right-click it, and then click Delete.