February 4, 2011 at 1:56 am
Hi
I need a demo on the following.Pls help me out
1.Data validating and error logging using ssis
2.Differential Upload
Step to followed to implement this
February 4, 2011 at 4:49 am
Those are advanced concepts that you just cannot explain in a few sentences. And certainly not data validation, you can write whole books on the subject.
For error logging: look into the standard logging capabilities of SSIS and into event handlers.
For differential load: you need a way to find only the data at the source that is new or has changed. This data you will load with SSIS into the data warehouse. You need also a way to distinguish between inserts and updates. Look into CDC and SCD.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply