Packt+ | Advance your knowledge in tech

You're reading from SQL Server 2017 Integration Services Cookbook Powerful ETL techniques to load and transform data from almost any source

Product type Paperback

Published in Jun 2017

Publisher Packt

ISBN-13 9781786461827

Length 558 pages

Edition 1st Edition

Languages

SQL

Tools

SQL Server

Concepts

Database Administration

Authors (6):

Cote

Dejan Sarka

Lah

David Peter Hansen

Samuel Lester

Olivier

+2 more

View More author details

Table of Contents (12) Chapters

Preface

1. SSIS Setup FREE CHAPTER

2. What Is New in SSIS 2016

3. Key Components of a Modern ETL Solution

4. Data Warehouse Loading Techniques

5. Dealing with Data Quality

6. SSIS Performance and Scalability

7. Unleash the Power of SSIS Script Task and Component

8. SSIS and Advanced Analytics

9. On-Premises and Azure Big Data Integration

10. Extending SSIS Custom Tasks and Transformations

11. Scale Out with SSIS 2017

Using SQL Server Management Studio to execute an SSIS package

In this recipe, you are going to use SQL Server Management Studio (SSMS) to prepare, and invoke, the execution of an SSIS package deployed to the SSISDB catalog.

Getting ready

Even if you have successfully completed the exercises in Chapter 2 , What Is New in SSIS 2016, follow these steps to create an SSIS environment, and configure the CustomLogging project:

In SSMS, open the Chapter06_Configuration.sql script located in the C:\SSIS2016Cookbook\Chapter06\Scripts folder.
Carefully review the script, and then execute it. The script will create the Chapter06 environment with a single environment variable, and associate it with the CustomLogging project. The cmgr_TestCustomLogging_CS variable will allow you to configure the connection manager used by the project.

How to do it...

Start SSMS, unless it is already running, and make sure that the Object Explorer is connected to the local SQL Server instance on your machine.
In the Object...