how to drop bad dates from excel file
Posted on 2011-09-22
Hi, what is the best way to drop a bad date within a ssis pkg. I load data from an excel file into a sql server but sometimes the data is dirty, like a date field will come in ##### or 0222-01-01 00:00:00.000. For these rows I want to load into tbl and the good rows into another tbl.
I tried using the derived column task to make sure the data is actually a date, but get the following error.
Configure error or truncation dispositions to redirect rows to the error output(s), or delete data flow transformations or destinations that are attached to the error output(s).