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
Instructor Details
Courses : 6
Specification: SSIS Real World Scenarios & Projects : Tricks of the Trade
|
4 reviews for SSIS Real World Scenarios & Projects : Tricks of the Trade
Add a review Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Price | $11.99 |
---|---|
Provider | |
Duration | 6.5 hours |
Year | 2020 |
Level | Intermediate |
Language | English |
Certificate | Yes |
Quizzes | No |
$99.99 $11.99
Ruben Madamba –
I really liked the way he explained the errors encountered during execution of the package. He pointed out how to fix the errors that may be caused within the data flow, control flow, or the package itself.
Sitakanta Nayak –
Good
Andrew Zoorob –
greeT
Rahul Sharma –
tricks saves time