Recording Create Change Dates

Jun 26, 2009 at 2:14 AM

Hi,

 

What is the best way to handle these sort of columns.  I would rather not use a trigger for this.  We have a standard which means we save the create and update date on every records, but I am unsure of the best way to handle this.  I was looking at the Audit keys, but they don't seem to handle dates.

 

Thanks for your advice.

Leigh.

Coordinator
Jun 29, 2009 at 9:06 PM

Interesting.  I'll have to keep that in mind - it does make some sense to track things that way.

Probably the best way to "track" things like that is to modify the Destinations, and/or OLE DB Command components you use to write your processed data back to the dimension table.  You can just place a "GETDATE()" on your SQL INSERT/UPDATE statement or use an SSIS package variable like System::StartTime to update rows with a Derived Column transformation.

Does that help?

Jun 29, 2009 at 11:22 PM

What I ended up doing is using defaults for the create date and modifying the update as you suggested for the update date.