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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics