SSis Training Chennai

Module 1

Introduction to Integration Services

Defining SQL Server Integration Services

Exploring the need for migrating diverse data

The role of business intelligence (BI)

Module 2

Illustrating SSIS architecture

Distinguishing between data flow pipeline and package runtime

Executing packages on the client side or hosted

Module 3

Upgrading legacy DTS

Executing existing DTS packages in the SSIS environment

Converting DTS packages to SSIS with the migration wizard

Logging migration results

Module 4

Implementing Tasks and Containers

Utilizing basic SSIS objects

Configuring connection managers

Adding data flow tasks to packages

Reviewing progress with data viewers

Assembling tasks to perform complex data migrations

Module 5

Operating system level tasks

Copying, moving and deleting files

Transferring files with the FTP task

Reading system information with WMI query language (WQL)

Module 6

Communicating with external sources

Sending messages through mail

Detecting system events with WMI

Module 7

Processing XML

Iterating XML nodes

Writing XML files from databases

Module 8

Extending Capabilities with Scripting

Writing expressions

Making properties dynamic with variables

Building expressions in Expression Builder

Module 9

Script Task

Extending functionality with the Script Task

Debugging, breakpoints, watches

Module 10

Transforming with the Data Flow Task

Performing transforms on columns

Converting and calculating columns

Transforming with Character Map

Module 11

Combining and splitting data

Profiling data-Merge, Union, Conditional Split

Multicasting and converting data

Module 12

Manipulating row sets and BLOB data

Aggregate, sort, audit and look up data

Importing and exporting BLOB data

Redirecting error rows

Module 13

Performing database operations

Implementing Change Data Capture (CDC)

Executing a SQL task

Bulk inserting data from text files

Module 14

Error Handling, Logging and Transactions

Organizing package work flow

Defining success, failure

completion and expression precedence constraints

Handling events and event bubbling

Module 15

Designing robust packages

Choosing log providers

Adapting solutions with package configurations

Auditing package execution results

Module 16

Administering Business Intelligence

Managing and securing packages

Storing packages in Package Store

msdb-Encrypting packages with passwords and user keys

Module 17

Integrating with other BI components

Displaying data in Reporting Services

Accessing package data with ADONET