SSIS (SQL Server Integration Services) Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  30 Days

About Course

A platform for creating enterprise-level data integration and data transformation solutions is provided by our SSIS (SQL Server Integration Services). Utilise Integration Services to load data warehouses, manage SQL Server objects and data, copy or download files, clean and mine data, and load complicated business challenges. Enrol today to earn your certification.

SSIS Training Course Syllabus

Introduction to SQL Server Integration Services Product History

✔ SSIS Package Architecture Overview

✔ Development and Management Tools

✔ Deploying and Managing SSIS Packages

✔ Source Control for SSIS Packages

SSIS for DBAs: Using SQL Server Management Studio

✔ The Import and Export Wizard

✔ Importing and Exporting Data

✔ Working with Packages

✔ Database Maintenance Plans

✔ Creating Database Maintenance Plans using SSMS

✔ Scheduling and Executing Plans

✔ Examining Database Maintenance Plan Packages

Business Intelligence Development Studio (BIDS)

✔ Launching BIDS

✔ Project templates

✔ The package designer

✔ The Toolbox

✔ Solution Explorer

✔ The Properties window

✔ The Variables window

✔ The SSIS menu

Introduction to Control Flow in MSBI

✔ Control Flow Overview

✔ Precedence Constraints

✔ Execute SQL Task

✔ Bulk Insert Task

✔ File System Task

✔ FTP Task

✔ Send Mail Task

Advanced Control Flow

✔ Containers – grouping and looping

✔ Web Service Task

✔ WMI tasks

✔ Analysis Services tasks

✔ Execute Process Task

✔ Execute Package Task

Introduction to Data Flow

✔ Data Flow Overview

✔ Data Sources

✔ Data Destinations

✔ Data Transformations

✔ Copy Column Transformation

✔ Derived Column Transformation

✔ Data Conversion Transformation

✔ Conditional Split Transformation

✔ Aggregate Transformation

✔ Sort Transformation

✔ Data Viewers

Variables and Configurations

✔ Variables Overview

✔ Variable scope

✔ SSIS system variables

✔ Using variables in control flow

✔ Using variables in data flow

✔ Using variables to pass information between packages

✔ Property expressions

✔ Configuration Overview

✔ Configuration options

✔ Configuration discipline

Debugging, Error Handling, and Logging

✔ SSIS debugging overview

✔ Breakpoints in SSIS

✔ SSIS debugging windows

✔ Control Flow: The OnError event handler

✔ Data Flow: Error data flow

✔ Configuring Package Logging

✔ Built-in log providers

Advanced-Data Flow in MSBI

✔ Revisiting data sources and destinations

✔ He Lookup Transformation

✔ Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations

✔ Multicast Transformation

✔ Merge and Merge Join Transformations

✔ Data Mining Query Transformation

✔ Data Mining Model Training Destination

✔ Slowly Changing Dimension Transformation

Extending SSIS through Custom Code

✔ Introduction to SSIS scripting

✔ SSIS script editor

✔ SSIS object model

✔ Script in Control flow: The Script Task

✔ Script in Data flow: The Script Component

✔ Introduction to SSIS component development

SSIS Package Deployment

✔ Configurations and deployment

✔ Deployment utility

✔ Deployment options

✔ Deployment security

✔ Executing packages – DTExec and DTExecUI

✔ Data Mining Model Training Destination

✔ Slowly Changing Dimension Transformation

SSIS Package Management

✔ SSIS Service

✔ Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

SSIS Training - Upcoming Batches

Coming Soon

AM IST

Weekday

Coming Soon

AM IST

Weekday

Coming Soon

PM IST

Weekend

Coming Soon

AM IST

Weekend

Don't find suitable time ?

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Preferred

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

SSIS Training FAQ'S

What is SQL Server Integration Services?

The following version of SQL Server software after SQL Server 2000 was SQL Server 2005, which saw the initial release of SQL Server Integration Services.A data extraction, transformation, and loading tool is called SSIS. Along with handling ETL operations, it is also capable of handling other activities like data profiling and file system manipulation.If you are familiar with C#.net or VB.net, you may use the script job to carry out batch activities much more effectively.

What is SQL Server Integration Services control flow integration?

By utilising the logical connectors between activities, SQL Server Integration Services control flow enables you to programme graphically how the tasks will run.Success, failure, or complete are the three fundamental logical linkages that you might employ.Additionally, you can manage more complicated circumstances in your control flow by using the FX (expression).

What is Data Transformation?

The data transformation stage creates the data for loading into the final target by applying a set of rules or functions to the extracted data from the source.

By learning through VISWA Online Trainings, advance in your job.

What kind of variables can you create?

In SQL Server Integration Services, both global variables and task-level variables can be created. These variables are the same as global and function-level variables for programmers. For the duration of the entire work, a global variable is accessible to all tasks. Task-created variables are only usable in that task.

Reviews

Quick Links