Tag: ETL

Script for Creating and Generating members for Date Dimensions: General Purpose

Posted on by Reza Rad

Date Dimension can be found in every Data Warehouse, because Date dimension is one of the most important factors of each operational system that users like to view reports based on date dimension. So the importance and requirement to a date dimension persuade me to write a t-sql script to generate records for date dimension. Read more about Script for Creating and Generating members for Date Dimensions: General Purpose[…]

My Session at Pass DW and BI Chapter – SSIS Catalog; Big step for ETL Framework

Posted on by Reza Rad

Hi folks, I will speak at 10th of August at Pass Data Warehousing and Business Intelligence Virtual Chapter. Session Title: SSIS Catalog; Big Step for ETL Framework Time: Fri August 10th 2:00 PM at NZDT , 12:00 PM at Brisbane = 9th August 10:00 PM EST Fri  August 10th 12pm – 1pm Brisbane, AU Timezone (GMT+10) (= Read more about My Session at Pass DW and BI Chapter – SSIS Catalog; Big step for ETL Framework[…]

SSIS Upsert With Lookup Transform

Posted on by Reza Rad

This is a very common question everywhere; how can I check if data is exists in destination table then update it, otherwise insert new records. This Scenario named Upsert in common ( Update / Insert ), there are lots of ways to do it, but in this post I’ll describe how to do it with Read more about SSIS Upsert With Lookup Transform[…]

Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS

Posted on by Reza Rad

There are lots of links which described how to UPSERT( Update / Insert ) between two SQL Server tables. which mostly used Lookup Transform with OLEDB Command, like this:http://www.insideit.fr/post/2010/06/17/Lookup-simple-sur-SSIS But when you work with MySQL there is a limitation, you can not use OLEDB Connections, you can use ODBC or ADO.NET Connectors from .NET to Read more about Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS[…]

PIVOT Transformation – SSIS – Complete Tutorial

Posted on by Reza Rad

Sometimes, you need to use PIVOT in SSIS. brief explanation of what PIVOT is from msdn is here: PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted Read more about PIVOT Transformation – SSIS – Complete Tutorial[…]