Now that our 5-month old son – Riley Cooper – is on the mend, I am hitting the speaking trail again!
09 Jan 2008: I’m presenting Testing The Database to the Triangle .Net User Group (TRINUG) Wednesday evening in Research Triangle Park, NC (location details).
12 Jan 2008: I’m presenting Incremental Loads With SSIS – by far my most popular SSIS Design Pattern post – at the Philadelphia Code Camp 2008.1.
If you read this blog and are attending, please introduce yourself!
:{> Andy
Say "hello" to Raleigh for me…
Will do Peter! Keep ’em straight down south for us.
:{> Andy
Dear Andy,
followed your approach and it is working well.
However, on one of the SCD II pacakges, there has been a new requriement. I have to keep all columns as historical. Meaning there will not be any overwrite/updates on any of the columns.
Now, I thought, all I need to do is to remove the second OLD DB Command for updating records, and keep everything else the same.
That is:
1. OLE DB Data Source,
2. Lookup Task, set up as ignore faliure
3. Conditional Split, with only one condition: New Rows as ISNULL(primary key)
4. OLE DB Destination
Is this the best approach still?
Thanks,
Kajo