Speaking in Raleigh and Philadelphia This Week

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

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>

3 thoughts on “Speaking in Raleigh and Philadelphia This Week

  1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.