Microsoft SQL Server 2012 – Implementing a Data Warehouse: Installing SSIS


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
SQL Server Integration Services (SSIS) is a component of SQL Server 2012, that for used for data extraction, transformation, and loading (ETL). SSIS can be installed during the SQL Server 2012 installation or as a separate component later on. Before installing SSIS there are a number of installation considerations that must be addressed first. This includes upgrading from previous versions of SQL, the use of Windows 32-bit or 64-bit and various security requirements. These topics are discussed in the course, along with topics on packaging, deploying and executing SSIS packages.

Target Audience
Data Warehouse Developers and Database Administrators who create and manage business intelligence solution as part of their daily tasks, which include implementing data warehouse databases, extracting transforming, and extracting data as part of an ETL solution, and data cleansing.

Prerequisites
none

Expected Duration (hours)
1.5

Lesson Objectives

Microsoft SQL Server 2012 – Implementing a Data Warehouse: Installing SSIS

  • recognize the different methods of managing SSIS package execution
  • describe reasons for monitoring the SSIS package execution
  • to describe the considerations for SSIS install
  • recognize the SSIS install procedure and its features
  • identify the features of SSIS deployment
  • recognize the stages involved in deployment of SSIS packages
  • deploy SSIS and SSIS Packages in SQL Server 2012
  • Course Number:
    md_dwsq_a06_it_enus

    Expertise Level
    Intermediate