We are in the phase of designing a datawarehouse ETL procedure in SSIS. This package takes care of loading the data from the source to staging tables and to all the corresponding dimension tables and the same is implemented for the Fact tables too. I am
trying to put a consistent timestamp for the record in the field CreateDateTime, this should be the timestamp of the package run(For instance: If the job is scheduled to run at 4AM I should have the date 2010-12-03 04:00:00.000 in the CreateDateTime). I am
trying to get 1 datetime value for all the records for each job run. If I use the system variable mins and secs change accordingly.
Thanks & Regards
View Complete Post