Skip to content

lesson-1-2-creating-the-deployment-project.md

Latest commit

 

History

History
44 lines (26 loc) · 2.17 KB

lesson-1-2-creating-the-deployment-project.md

File metadata and controls

44 lines (26 loc) · 2.17 KB
title Step 2: Creating the Deployment Project
description Lesson 1-2 - Creating the Deployment Project
author chugugrace
ms.author chugu
ms.date 03/01/2017
ms.service sql
ms.subservice integration-services
ms.topic tutorial

Lesson 1-2 - Creating the Deployment Project

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

To create the Integration Services project

  1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Data Tools.

  2. On the File menu, point to New, and then click Project to create a new [!INCLUDEssISnoversion] project.

  3. In the New Project dialog box, select Integration Services Project in the Templates pane.

  4. In the Name box, change the default name to Deployment Tutorial. Optionally, clear the Create directory for solution check box.

  5. Accept the default location, or click Browse to locate the folder you want to use.

  6. In the Project Location dialog box, click the folder, and then click Open.

  7. Click OK.

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

Next Task in Lesson

Step 3: Adding Packages and Other Files

See Also

Integration Services (SSIS) Projects