MSBI Online Training |Training| Support- 3092003848

[Davidjhon]

We Provide Online Training |Training| on   MSBI   with Real Time Experts

Course Outline:

Introduction to Integration Services

Defining SQL Server Integration Services (SSIS)

• Exploring the need for migrating diverse data
• The role of Business Intelligence (BI)

SSIS Architecture and Tools

Managing heterogeneous data

• Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
• Running wizards for basic migrations
• Creating packages for complex tasks

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 environment configurations

Simplifying deployments

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

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
• Migrating multiple files with FOREACH container
• Handling multiple iteration of data loading using FORE LOOP container.
• Usage of Sequence Container with real time examples.

Operating system-level tasks

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

Extending Capabilities with Scripting

Writing expressions

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

Script Task

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

Transforming with the Data Flow Task

Performing transforms on columns

• Converting and calculating columns
• Transforming with Character Map

Profiling, combining and splitting data

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

Manipulating row sets and BLOB data

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

 

You can reach us @   3092003878 or Email us: [email protected]

 

 

Edited August 14, 2016 by Davidjhon
side heeding