Loading

(5) | 546 Learners | 25 Hrs

Home / Courses / SSIS Training

SSIS Training



SSIS Training Overview

Course Duration 25 hrs
Training Options Live Online / Self-Paced / Classroom
Live Projects 3
Certification Pass Guaranteed

SSIS training course gives a detailed overview of dataflow transformation, data integration, customizations and deployment procedures. SSIS corporate and online training teaches you data extraction, transformation, and integration to align with business requirements. After SSIS online training, you will become an expert in gathering data from XML, flat files, and relational data sources.

SSIS Classroom and Online Training Course Objective

After completion of the SSIS training course, you will be an expert in the following concepts: 

  • Know the data integration process
  • Overview of data warehousing and ETL concepts
  • Data profiling and cleansing for enhancing data quality
  • Connect to a data source with Connection Managers
  • PIVOT, UNPIVOT, and Data transformation 
  • Know the features of SCD and its various types
  • Learn to construct SSIS packages and configure it
  • Event handlers and constraints in SSIS
  • Automation of the SSIS object model

Business Intelligence, Software and ETL Developers, Data and Database Warehousing Professionals will benefit from these SSIS training classes. 

SSIS Training Course Curriculum

Module 1: SQL Server Integration Services

  • Overview of SSIS Package Architecture 
  • Overview of SSIS & Data Warehouse
  • Basic ETL Entities in SSIS
  • Management and data Tools
  • Export and Import Wizard

Module 2: Data Flow Concept

  • Overview of Data Flow
  • Data Sources
  • Data Destinations
  • Transformations in Data Flow
  • Data Viewers

Module 3: Data Sources Concepts

  • Excel Source
  • OLE DB Source
  • Flat File Source
  • XML Source

Module 4: Data Flow Transformations

  • Aggregate and Audit Transformation
  • Character Map Transformation
  • Copy Column Transformation
  • Conditional Split Transformation
  • Derived Column Transformation
  • Data Conversion Transformation
  • Script component Transformation
  • OLE DB Command Transformation
  • Multicast Transformation
  • Percentage Sampling Transformation
  • Sort Transformation
  • Row Count Transformation
  • Union All Transformation
  • Character Map Transformation
  • Audit Transformation
  • Copy Column Transformation
  • Data Mining Query Transformation

Module 5: Advanced Data Flow Concept

  • Lookup Transformation
  • Merge and Merge Join Transformation
  • Slowly Changing Dimension Transformation
  • Pivot Transformation
  • Import and Export Transformation
  • Unpivot Transformation
  • Term Extraction and lookup Transformation
  • Fuzzy Lookup and Grouping Transformation

Module 6: Data Flow Destinations

  • Know Data Reader Destination
  • What is the Excel Destination?
  • What is the Flat File Destination?
  • OLE DB Destination

Module 7: Control Flow Concepts

  • Overview to Control Flow
  • Precedence Constraints
  • Know about the Execute SQL Task
  • Understand the Bulk Insert Task
  • Learn the File System Task
  • FTP Task
  • Send Mail Task
  • Bulk Insert Task
  • Data Flow Task
  • Execute Package Task
  • Web Service Task
  • Execute Process Task
  • Backup database Task
  • XML Task
  • WMI Event Watcher Task
  • Analysis Services Processing Task

Module 8: Advanced Control Flow

  • For Loop and each loop Container
  • Sequence Container

Module 9: Variables and Configurations

  • Overview of Variables
  • Variable scope
  • Using variables in control and data flow
  • SSIS system variables
  • Configuration Overview
  • Property expressions
  • Configuration options and discipline

Module 10: Error Handling, Debugging, and Logging

  • The On Error event handler
  • Error data flow
  • Overview of SSIS debugging
  • SSIS Breakpoints
  • Configure Package Logging
  • Built-in log providers

Module 11: Extend SSIS through Custom Code – Scripting

  • SIS Customizations with .NET
  • SSIS scripting overview
  • SSIS script editor
  • SSIS object model
  • The Script Task and Component
  • SSIS component development overview

Module 12: SSIS Package Deployment

  • Deployment and Configurations
  • Deployment options

Conclusion:

Candidates who undergo the SSIS training course will get an opportunity to work on real-time projects under the able guidance of certified instructors. Advance your career by learning the SSIS course online from CA Software Technologies (CAST), the reputed training institute in Hyderabad and Bangalore. We provide Certification program, corporate and online training classes as per student’s requirements.  

SSIS Training Options

For Corporates

Live Instructor Led SSIS Training
  • Live Presentation of theory and demonstration of features and tasks of the Denodo
  • Learn as per a daily schedule.
  • You get recordings of each training session that you attend.
  • Clarify doubts at the beginning of each training session.
  • Delivered through Goto Meeting.
  • Completely Customizable Course Content & Schedule.
  • Certification Guidance Provided.
SSIS Training Classroom Training
  • F2F interactive presentation of theory and demonstration of features and tasks of the Denodo
  • Learn as per full day schedule with discussions & exercises.
  • No recordings available, however you can choose self-paced video if needed.
  • Doubts Clarifications.
  • Delivered through F2F as trainer conducts the training at your facility.
  • Completely Customizable Course Content & Schedule.
  • Certification Guidance Provided.
Self Paced Learning
  • High Quality videos built by industry experts with theory and demonstration of features and tasks of the Denodo
  • Learn at your Convenience.
  • You get pre-defined recordings.
  • Delivered through LMS.
  • Fixed Course Content.
  • Certification Guidance Provided.

SSIS Training Upcoming Batches

Mon-28-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Tue-29-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Wed-30-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Thu-01-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Fri-02-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,


Sat-03-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Sun-04-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Sat-10-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Sun-11-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Sat-17-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Sun-18-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Sat-24-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,
Sun-25-2022

IST: 6 to 7 AM & PM,
IST: 7 to 8 AM & PM,
IST: 8 to 9 AM & PM,
IST: 9 to 10 AM & PM,


24/7

Pick any date from calender
Select your suitable day's of this month
Facielitating all, 365 day's for your best learning
Drop your valuable Request


comment-img
comment-img
comment-img

What our Customer say's

"Great explanation of concepts through live examples, this helped me to link the topics and understand the connect between various topics of Tibco Spotfire Admin. Excellent. Great learning experience.. Thanks a lot CAST!!"

Mr. Chandra

Certified Student

(4.5)

"Thank You for the sessions that helped me gaining knowledge in Spotfire. Trainers experience helped me to get detailed information regarding the key concepts and challenging tasks in real time. Thanks once again"

Mr. Arun

Certified Student

(4.5)

"The trainer of the casoftwaretechnologies.com is top rated customer provided the more useful information In Tibco Spotfire Admin Training than the normal which helped me to improve my skills.. Thanks to CA software technologies"

Mrs. Ramya

Certified Student

(4)

SSIS Training Certification !

Become a successful online learner

Upgrade to new skills and share your certificate of achievement with the community.

Fast track your career

Use the coveted certification to your advantage and charge up the corporate ladder.

Validate your learning

Receive the coveted certificate from CA Software Technologies

Cooming Soon

Features

Online guidance session or Instructor led course delivery online

24*7 delivery of learning through live lectures and demonstrations by industry experts. Weekend class: 8 sessions of 1 to 4+ hours each in Online Mentorship Mode

Hands-on experience with Real-time scenarios

End to end training with real-time practical exposure. Get to experience on projects using key progressive concepts.

Gauge learners understanding

Formative evaluation of the trainees at the end of each class.

Unlimited Online Access

You get Lifetime Unlimited Online Training Videos, presentations, installation guide to enhance your knowledge

7×24 technical support expertise

24/7/365 technical support with powerful ticket tracking system for life

Certification

Stay ahead of the game with our certificate after course completion

Assessments

Each class will be followed by a test to assess your learning.

Want to Become An Instructor?

Contact Us

Experts Available 24 x 7

+91 912 110 4115
info@casoftwaretechnologies.com

Enquiry Now
+91 912 110 4115
Experts Available 24 x 7