Deploy SSIS Solutions

Introduction

The Deploy SSIS Solutions module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

1. Deploy SSIS Package using the Deployment Wizard

2. Create and Configure SSISDB Catalog and Inspect SSIS Package Metadata

3. Use DTUTIL and Deploy Packages on Multiple Servers

Exercise 1 - Deploy SSIS Package using the Deployment Wizard

In this exercise, you will learn the following in Microsoft SQL Server 2012:

• Deploy SSIS package using the Deployment wizard

Exercise 2 - Create and Configure SSISDB Catalog and Inspect SSIS Package Metadata

In this exercise, you will learn the following in Microsoft SQL Server 2012:

• Create an SSISDB catalog and configure the catalog to deploy an SSIS package
• Validate SSIS package to inspect the Package Metadata

Exercise 3 - Use DTUTIL and Deploy Packages on Multiple Servers

In this exercise, you will learn the following in Microsoft SQL Server 2012:

• Use DTUTIL to deploy an SSIS package on the File system in the local server, local SQL Server database, and on a remote SQL Server database"