Skip to content

Latest commit

 

History

History
91 lines (59 loc) · 9.63 KB

deploy-packages-with-ssis.md

File metadata and controls

91 lines (59 loc) · 9.63 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords
Deploy Packages with SSIS
Deploy Packages with SSIS
chugugrace
chugu
08/20/2018
sql
integration-services
quickstart
intro-quickstart
deployment tutorial [Integration Services]
deploying packages [Integration Services]
SSIS, tutorials
Integration Services, tutorials
deploying packages [Integration Services], installing
SQL Server Integration Services, tutorials
walkthroughs [Integration Services]
deployment utility [Integration Services]
deploying packages [Integration Services], configurations

Deploy Packages with SSIS

[!INCLUDEsqlserver-ssis]

[!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssISnoversion] provides tools that make it easy to deploy packages to another computer. The deployment tools also manage any dependencies, such as configurations and files that the package needs. In this tutorial, you will learn how to use these tools to install packages and their dependencies on a target computer.

First, you will perform tasks to prepare for deployment. You will create a new [!INCLUDEssISnoversion] project in [!INCLUDEssBIDevStudioFull] and add existing packages and data files to the project. You will not create any new packages from scratch; instead, you will work only with completed packages that were created just for this tutorial. You will not modify the functionality of the packages in this tutorial; however, after you have added the packages to the project, you might find it useful to open the packages in [!INCLUDEssIS] Designer and review the contents of each package. By examining the packages, you will learn about package dependencies such as log files and about other interesting features of the packages.

In preparation for deployment, you will also update the packages to use configurations. Configurations make the properties of packages and package objects updatable at run time. In this tutorial, you will use configurations to update the connection strings of log and text files and the locations of the XML and XSD files that the package uses. For more information, see Package Configurations and Create Package Configurations.

After you have verified that the packages run successfully in [!INCLUDEssBIDevStudioFull], you will create the deployment bundle to use to install the packages. The deployment bundle will consist of the package files and other items that you added to the [!INCLUDEssISnoversion] project, the package dependencies that [!INCLUDEssISnoversion] automatically includes, and the deployment utility that you built. For more information, see Create a Deployment Utility.

You will then copy the deployment bundle to the target computer and run the Package Installation Wizard to install the packages and package dependencies. The packages will be installed in the msdb SQL Server database, and the supporting and ancillary files will be installed in the file system. Because the deployed packages use configurations, you will update the configuration to use new values that enable packages to run successfully in the new environment.

Finally, you will run the packages in [!INCLUDEssManStudioFull] by using the Execute Package Utility.

It is the goal of this tutorial to simulate the complexity of real-life deployment issues that you may encounter. However, if it is not possible for you to deploy the packages to a different computer, you can still do this tutorial by installing the packages in the msdb database on a local instance of [!INCLUDEssNoVersion], and then running the packages from [!INCLUDEssManStudioFull] on the same instance.

Estimated time to complete this tutorial: 2 hours

What You Learn

The best way to become acquainted with the new tools, controls, and features available in [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssISnoversion] is to use them. This tutorial walks you through the steps to create an [!INCLUDEssISnoversion] project and then add the packages and other necessary files to the project. After the project is complete, you will create a deployment bundle, copy the bundle to the destination computer, and then install the packages on the destination computer.

Prerequisites

This tutorial is intended for users who are already familiar with fundamental file system operations, but who have limited exposure to the new features available in [!INCLUDEssNoVersion] [!INCLUDEssISnoversion]. To better understand basic [!INCLUDEssISnoversion] concepts that you will put to use in this tutorial, you might find it useful to first complete the following [!INCLUDEssISnoversion] tutorial: SSIS How to Create an ETL Package.

On the source computer

The computer on which you create the deployment bundle must have the following components installed:

On the destination computer

The computer to which you deploy packages must have the following components installed:

If you plan to deploy packages to the same computer as the one on which you create the deployment bundle, that computer must meet requirements for both the source and destination computers.

Lessons in This Tutorial

Lesson 1: Preparing to Create the Deployment Bundle
In this lesson, you will get ready to deploy an ETL solution by creating a new [!INCLUDEssISnoversion] project and adding the packages and other required files to the project.

Lesson 2: Create the Deployment Bundle in SSIS
In this lesson, you will build a deployment utility and verify that the deployment bundle includes the necessary files.

Lesson 3: Install SSIS Packages
In this lesson, you will copy the deployment bundle to the target computer, install the packages, and then run the packages.