SQLBIGURU

Course Curriculum

1) Introduction to SQL Server Integration Services (SSIS)

  • Lecture 1 Introduction

Microsoft SQL Server Integration Services (SSIS) is the toolset used to help you implement data integration process applications among your business application system's files and databases. SSIS is much more than a simple extract, transform and load (ETL) process. SSIS enables database administrators and application developers to design, implement and manage complex, high-performance ETL applications. Using SSIS, you can select data from one or more sources and standardize, join, merge, cleanse, augment, derive, calculate and perform just about any other function and operation required for your data integration applications. SSIS also provides procedures to automate many of the administrative functions for SQL Server databases, tables, On-Line Analytical Processing (OLAP) Cubes and many other functions for components of SQL Server.

2) Creating a Package and Processing of Flat Files

  • Lecture 1 Importing a Flat File into a SQL Server database
    Preview
  • Lecture 2 Importing multiple Flat Files dynamically into a SQL Server Database
  • Lecture 3 Exporting SQL Server Query Results into Flat Files

3) Using Change Data Capture (CDC)

  • Lecture 1 Incremental Loading using Change Data Capture Part-I
    Preview
  • Lecture 2 Incremental Loading using Change Data Capture Part-II

4) Processing of Excel Files

  • Lecture 1 Dealing of Excel Connection Manager Driver Issues
  • Lecture 2 Loading of Excel Files and Examining the Results

5) Iteration of Data Transformation Items

  • Lecture 1 Union ALL
  • Lecture 2 Lookup
  • Lecture 3 Sorting
  • Lecture 4 Re-directing Unmatched Rows
  • Lecture 5 Data Conversion
  • Lecture 6 Derived Column
  • Lecture 7 Conditional Split

6) Error Handling

  • Lecture 1 Configuring DFT Error Output and Redirecting bad data
  • Lecture 2 Loading error records into a table with specific error description (Script Task)
  • Lecture 3 Error Handling by using Event Handlers

7) Package Deployment

  • Lecture 1 Deploying a package using SSDT and executing it on SQL Server
  • Lecture 2 Deploying a package using command-line and executing it on File System

8) Conclusion

  • Lecture 1 Resume Tips

*For each video a PDF and Power Point slides are available where it illustrates you stepswise of creating each task and definitions of some Data Flow and Control Flow Items.

 

*Variables and Expressions are part of Videos which are helpful to accomplish dynamic run time tasks.