SSIS or t-ql to cleanse incorrect dates
Hello!
I need to wash data from a source system when inserting into the data warehouse. Dates from the source system can be 2102-05-12. Any date with year larger than 2049 is to be considered as an error. What components in SSIS should I use to move these records
to an error table and send an e-mail notification? My alternative is to use a stored procedure and manage it in T-sql...
May 24th, 2012 5:09am
A conditional split should work just fine.
You can use the following condition:
YEAR(myDateColumn) > 2049
MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
May 24th, 2012 5:14am