| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Step 2: Creating the Deployment Project |
Lesson 1-2 - Creating the Deployment Project |
chugugrace |
chugu |
03/01/2017 |
sql |
integration-services |
tutorial |
[!INCLUDEsqlserver-ssis]
In [!INCLUDEssISnoversion], the deployable unit is an [!INCLUDEssISnoversion] project. Before you can deploy packages, you must create a new [!INCLUDEssISnoversion] project and add all the packages and any ancillary files that you want to deploy with the packages to that project.
-
Click Start, point to All Programs, point to Microsoft SQL Server, and then click SQL ServerSQL Server Data Tools.
-
On the File menu, point to New, and then click Project to create a new [!INCLUDEssISnoversion] 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.
-
Click OK.
-
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.