Overview of ETL Architecture In a data warehouse, one of the main parts of the entire system is the ETL process. ETL is the system that reads data from the source system, transforms the data according to the business logic, and finally loads it into the warehouse. While fetching data from the sources can seem […]
2019-10-21
11,247 reads
(2019-May-24) Data Flow as a data transformation ...
2019-05-24
2019-05-22
2019-05-22
Azure Data Factory is more of an orchestration tool than a data movement tool, yes. It’s like using SSIS, with control flows only. Once they add Mapping Data Flows...
2019-05-08
Enjoy! :{>
The post The Recording for Using Biml as an SSIS Design Patterns Engine is Available! appeared first on AndyLeonard.blog().
2019-05-06
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
The...
2019-05-06
As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you...
The...
2019-04-26
It is not a joke: SSIS is available for Visual Studio 2019 as a preview. Whoa, hold on. SQL Server 2019 hasn’t been released yet? But there’s already an...
The...
2019-04-26
Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and keeps on failing with the following error: The error is succinct and direct to...
2019-04-24
I know, I know, I’m on #teamexevents so I think that Extended Events can...
By Angela-Henry
I am super excited to announce that I have been selected to speak at...
I don’t know how many of you are working with Windows Core these days...
Does anyone have any recommendations for sites which publish the daily LIBOR rates in...
Good morning all i need your expertise to help me on a code...
Hi Guys, Here is my "Sample" source data. ID,DKey,SKey,InvType ,PID,PAmount,CAmount,AAmount 1 ,123 ,456 ,Write-Off,789,$505...
Ask SSC