Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com
EncartaLabs

MicroSoft SQL Server Integration Services (SSIS)

( Duration: 4 Days )

In MicroSoft SQL Server Integration Services (SSIS) training course, you will gain the skills to improve business intelligence capabilities by automating complex migration tasks and auditing the success or failure of migration processes. You will learn to transform data among heterogeneous data sources - such as text files, Oracle, Access, XML, ODBC and OLE DB - and effectively and securely managing data migration across various platforms.

By attending MicroSoft SQL Server Integration Services (SSIS) workshop, delegates will learn to:

  • Solve data management problems by migrating and processing data
  • Perform nonstandard imports and exports using the Script component
  • Assemble tasks to perform complex data migrations
  • Extract, Transform, and Load (ETL) data
  • Incrementally migrate data from SQL Server data sources using Change Data Capture (CDC)
  • Deploy packages to an SSIS catalog

  • Familiarity with relational database management systems, programming concepts, and SQL language

This MicroSoft SQL Server Integration Services (SSIS) class is ideal for SQL Server developers, administrators and analysts who need to migrate and transform data among diverse platforms.

COURSE AGENDA

1

Introduction to Integration Services

  • Defining SQL Server Integration Services (SSIS)
  • Exploring the need for migrating diverse data
  • The role of Business Intelligence (BI)
2

Managing heterogeneous data

  • Managing heterogeneous data
  • Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
  • Running wizards for basic migrations
  • Creating packages for complex tasks
  • Explore other supported data sources, such as Hadoop and NoSQL
3

Illustrating SSIS architecture

  • Distinguishing between data flow pipeline and package runtime
  • Executing packages on the client side or hosted in the SSIS service
  • Bulletproofing a package with package environments
  • Package restartability with checkpoint files
4

Simplifying deployments

  • Distinguishing between project and package deployment modes
  • Deploying packages to the SSISDB
  • Running packages from SQL Server
  • Leveraging package parameters
5

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
  • Migrating multiple files with FOREACH container
6

Operating system-level tasks

  • Copying, moving and deleting files
  • Transferring files with the FTP task
  • Communicating with external sources
  • Sending messages through mail
7

Processing XML

  • Iterating XML nodes
  • Writing XML files from databases
8

Writing expressions

  • Making properties dynamic with variables
  • Utilizing expressions in loop iterations
9

Script Task

  • Extending functionality with the Script Task
  • Debugging, breakpoints and watches
10

Performing transforms on columns

  • Converting and calculating columns
  • Transforming with Character Map
11

Profiling, combining and splitting data

  • Merge, Union and Conditional Split
  • Multicasting and converting data
12

Manipulating row sets and BLOB data

  • Aggregate, sort, audit and look up data
  • Importing and exporting BLOB data
  • Redirecting error rows
13

Performing database operations

  • Executing a SQL task
  • Bulk inserting data from text files
14

Organizing package workflow

  • Defining success, failure, completion and expression precedence constraints
  • Handling events and event bubbling
15

Designing robust packages

  • Choosing log providers
  • Adapting solutions with package configurations
  • Auditing package execution results
  • Accessing package data with ADO.NET

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top