Page 194 - DCAP508_DATABASE_ADMINISTRATION

Database Administration Deepak Mehta, Lovely Professional University

Notes Unit 14: SQL Server Integration Services

CONTENTS
Objectives

Introduction
14.1 Meaning of SSIS
14.2 The SSIS Import/Export Wizard
14.3 Process to Import and Export Data Into and From SQL Server

14.4 Features of the Data Flow Task
14.5 SSIS Components
14.6 Summary
14.7 Keywords

14.8 Review Questions
14.9 Further Readings

Objectives

After studying this unit, you will be able to:
Understand the meaning of SSIS

Describe the features of SSIS
Discuss how to create a SSIS Package
Know about the components of a SSIS Package

Learn how to use SQL Server Import and Export Wizard to create a data-transfer package.
Introduction

A very simple way to know about SSIS is that it’s the solution for automating SQL Server. SSIS
provides a way to build packages made up of tasks that can move data around from place to
place and alter it on the way. There are visual designers (hosted within Business Intelligence
Development Studio) to help you build these packages as well as an API for programming SSIS
objects from other applications. In this unit, you’ll learn the various features of SSIS, how to
import and export data into and from SQL server as well as how to build and use SSIS packages.

14.1 Meaning of SSIS

SQL Server Integration Services (SSIS) is a platform for building high performance data integration
and workflow solutions. It allows creation of packages or SSIS packages which are made up of
tasks that can move data from source to destination and alter it if required.
SSIS is basically an ETL (Extraction, Transformation, and Load) tool whose main purpose is to do
extraction, transformation and loading of data but it can be used for several other purposes for
example, to automate maintenance of SQL Server databases, update multidimensional cube data
etc., as well.

188 LOVELY PROFESSIONAL UNIVERSITY