SSIS Real World Scenarios & Projects : Tricks of the Trade

SSIS Real World Scenarios & Projects : Tricks of the Trade, available at $59.99, has an average rating of 4.8, with 33 lectures, based on 341 reviews, and has 2173 subscribers.

You will learn about Three Real World Scenario Based Projects Expressions Parameters Debugging and Troubleshooting Project Deployment This course is ideal for individuals who are Intermediate Microsoft Business Intelligence developers interested in deepen the knowledge in SSIS Technology or Who wants to work on some projects in SSIS Technology or Also wants to crack interviews It is particularly useful for Intermediate Microsoft Business Intelligence developers interested in deepen the knowledge in SSIS Technology or Who wants to work on some projects in SSIS Technology or Also wants to crack interviews.

Enroll now: SSIS Real World Scenarios & Projects : Tricks of the Trade

Summary

Title: SSIS Real World Scenarios & Projects : Tricks of the Trade

Price: $59.99

Average Rating: 4.8

Number of Lectures: 33

Number of Published Lectures: 32

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 32

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Three Real World Scenario Based Projects
Expressions
Parameters
Debugging and Troubleshooting
Project Deployment

Who Should Attend

Intermediate Microsoft Business Intelligence developers interested in deepen the knowledge in SSIS Technology
Who wants to work on some projects in SSIS Technology
Also wants to crack interviews

Target Audiences

Intermediate Microsoft Business Intelligence developers interested in deepen the knowledge in SSIS Technology
Who wants to work on some projects in SSIS Technology
Also wants to crack interviews

This Microsoft SQL Server SSIS is an intermediate level training course and it is the part of MSBI. You have to have the knowledge of basic tools and package creation. This SQL Server Integration Services course using SSDT contains three projects along with other tricks based on real world scenarios. All the projects are developed step by step. In one project you can learn how to perform ETL operation for the data warehouse using SSIS as well . The contents of this online SSIS business intelligence video tutorial on Udemy as follows.

How to use Temporary Table in SSIS Package

Transferring Data from OLTP to Staging Table

Transferring data from Staging to Datawarehouse

Testing Metadata of the files and Loading the data

How to execute Foreach Loop Fixed Number of Times

SSIS Expression to get the File Name from the complete File Path

SSIS Expression to separate Name and Date Component of a file

YYYYMMDD date format using SSIS expression

Compress and Uncompress Folder using Winrar in SSIS

Parameter Settings of the Project

Testing the existence of Compressed File

Extracting ZIp File From Shared Folder to Local Processed Folder

Testing Date Component of each file with the Current Date

Dynamically Deciding which file to load in which table

ETL Operations

ETL with Lookup Option

Shared Folder Transfer and Naming Conventions

Debugging and Troubleshooting SSIS Packages

Breakpoints , Watch Windows and Data Viewer

Troubleshooting Problematic Records Using Data Flow Paths

Troubleshooting with Precedence Constraints

Deploying the Packages to Integration Services Catalog

Setting up Test and Production Environment

Automating the Package Execution and Checking the Reports of Execution

Course Curriculum

Chapter 1: Introduction

Lecture 1: Topics covered in this course

Lecture 2: How to use Temporary Table in SSIS Package

Lecture 3: Please download Scripts and Files used in this course

Chapter 2: Project 1 – OLTP , Staging and Datawarehouse

Lecture 1: ETL Project Theory

Lecture 2: Transferring Data from OLTP to Staging Table

Lecture 3: Transferring data from Staging to Datawarehouse

Chapter 3: Project2 – Testing Metadata of the files and Loading the data

Lecture 1: Project 2 – Part 1

Lecture 2: Project 2 – Part 2

Lecture 3: Project 2 – Part 3

Lecture 4: Project 2 – Part 4

Chapter 4: Before Project 3

Lecture 1: How to execute Foreach Loop Fixed Number of Times

Lecture 2: SSIS Expression to get the File Name from the complete File Path

Lecture 3: SSIS Expression to separate Name and Date Component of a file

Lecture 4: YYYYMMDD date format using SSIS expression

Lecture 5: Compress and Uncompress Folder using Winrar in SSIS

Chapter 5: Project 3

Lecture 1: Project Scenario Explained

Lecture 2: Parameter Settings of the Project

Lecture 3: Testing the existence of Compressed File

Lecture 4: Extracting Zip File From Shared Folder to Local Processed Folder

Lecture 5: Testing Date Component of each file with the Current Date

Lecture 6: Dynamically Deciding which file to load in which table

Lecture 7: ETL Operations

Lecture 8: ETL with Lookup Option

Lecture 9: To Do Task

Lecture 10: Shared Folder Transfer and Naming Conventions

Chapter 6: Debugging and Troubleshooting SSIS Packages

Lecture 1: Breakpoints , Watch Windows and Data Viewer

Lecture 2: Troubleshooting Problematic Records Using Data Flow Paths & Script Component

Lecture 3: Troubleshooting with Precedence Constraints

Chapter 7: Project Deployment

Lecture 1: Deploying the Packages to Integration Services Catalog

Lecture 2: Setting up Test and Production Environment

Lecture 3: Automating the Package Execution and Checking the Reports of Execution

Lecture 4: Bonus Lecture

Instructors

Vikas Munjal
SQL Server | MSBI Microsoft Certified Trainer & Consultant

Rating Distribution

1 stars: 8 votes
2 stars: 7 votes
3 stars: 29 votes
4 stars: 104 votes
5 stars: 193 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu