SSIS Training

image

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500.


Installing SQL Server Business Intelligence Tools

  • Installation Requirements
  • Steps to Install SSRS, SSIS and SSAS
  • Navigating the SQL Server Data Tools Development Environment
  • New Features to SQL Server 2014 Business Intelligence

Integration Services Architecture

  • Architecture of the SSIS Data Engine
  • Using Data Transformation Tasks
  • Managing Connections to Sources and Destinations
  • ADO.NET Data Source and Destination
  • Understanding Data Buffers
  • Control Flow Tasks and Containers

Data Transformations

  • Converting Data Types
  • Merging Data from Multiple Sources
  • Splitting Data to Multiple Destinations
  • Counting Rows
  • Sampling and Sorting Records
  • Copying Columns

Advanced Data Transformations

  • Filling in Missing Data with Lookups
  • Locating Near Duplicate Rows with Fuzzy Grouping
  • Adding Audit Information to Results
  • Counting the Occurrence of Keywords
  • Sending Rows That Process Correctly and Incorrectly to Different Destinations
  • Respond to Truncation Errors

Common SSIS Tasks

  • Executing SQL Statements
  • Connecting to FTP Servers
  • Sending E-mail
  • Notifying Administrators of Errors
  • Completing Bulk Inserts
  • Copying, Moving and Deleting Files and Folders

SSIS Administration and Automation

  • Deploying SSIS Routines
  • Manually Running SSIS Routines
  • Automating SSIS Execution
  • Configuring Notifications for Execution Success, Failure or Both
  • SSIS Security
  • Troubleshooting Techniques