SQL Server Integration Services

  • 4.5/5.0
  • 1000+ Enrolled
  • All levels
  • Last updated 1/2025
  • English

Course description

SSIS course is designed to provide participants with a comprehensive understanding of SQL Server Integration Services (SSIS) for data integration, ETL (Extract, Transform, Load), and data warehousing solutions. SSIS is a powerful tool that allows you to automate the process of data migration, data transformation, and data synchronization between various data sources.

The course will cover both the basic and advanced features of SSIS, including data flow tasks, control flow tasks, transformations, sources, destinations, and debugging techniques. By the end of this course, participants will be able to design, deploy, and maintain complex ETL solutions using SSIS.

Prerequisites :
  • Basic knowledge of SQL
  • Experience with Microsoft SQL Server
  • Familiarity with Data Warehousing Concepts
  • Knowledge of Basic Programming Concepts
  • Experience with File Systems and Data Sources
What you’ll learn

  • SSIS Over Flow

  • Data Conversion Transformation
  • Multicast Transformation
  • Conditional Split Transformation
  • Sort Transformation
  • Merge Transformation
  • Merge Join Transformation
  • Union All Transformation
  • Aggregate Transformation
  • Derived Column Transformation
  • OLEDB Command
  • Row Count
  • Copy Column
  • Character Map
  • Slowly Changing Dimension
  • Script Component
  • Cache Transformation
  • Lookup Transformation
  • Fuzzy Lookup File

  • Flat File
  • Excel File
  • OLEDB Source

  • Excel
  • Flat File
  • OLEDB Destination
  • Record Set
  • SQL Server

  • Bulk Insert Task
  • Execute Package Task
  • Execute Process Task
  • File System Task
  • FTP Task
  • Split Task
  • Send Mail Task

  • For Loop
  • For Each Loop
  • Sequence Container

  • Precedence Constraint
  • Data Enable Viewer
  • Dynamic Connection
  • Debugging
  • Check Points
  • Break Points

  • Configuration File
  • Logging File
  • Event Handling
  • Deployment
  • Changed Data Capture
Enroll now
FAQ's
SSIS (SQL Server Integration Services) is a Microsoft tool used for building ETL (Extract, Transform, Load) workflows. It helps move and transform data between different sources like databases, Excel files, or cloud systems. In real-world projects, SSIS is used to automate data integration, cleansing, and loading into data warehouses for reporting and analysis.
No, prior knowledge of SQL Server is not mandatory to learn SSIS. The course introduces SQL Server basics before diving into SSIS concepts. However, having a basic understanding of SQL can make it easier to grasp ETL processes and workflow creation.
Yes, you will get hands-on experience with data integration and transformation using SSIS. The course includes practical exercises to build ETL packages, connect data sources, and apply transformation tasks. This real-time practice helps you apply concepts directly to real-world scenarios.
SSIS training with projects typically takes around 4 to 6 weeks to complete, depending on your learning pace. The course includes step-by-step modules, hands-on labs, and real-world ETL projects. This duration ensures you gain both theoretical knowledge and practical skills.
Yes, you can learn SSIS online and still receive practical guidance throughout the course. Online training includes live sessions, recorded videos, hands-on labs, and mentor support. This ensures you get real-time help while working on ETL tasks and projects.

Course Information

  • Course Name Looker BI
  • Lectures 30
  • Duration 4h 50m
  • Level Beginner to Expert
  • Course Type Online/Offline
  • Language English
  • Faculty / Exp Keshav / 5yrs
  • Certificate Yes
Enroll a free demo class now

Our Courses