Dealing with BAD Data in SSIS - 06-24-2010 , 10:47 AM
I have a simple table with five columns. One of the column is a
When I import the data into a datetime field I get the error: An OLE
DB error has occurred. Error code: 0x80004005. Description:
"Invalid character value for cast specification".
As it turns out the error occurs when it hits a date with this value
Can anyone suggest a method of dealing with this issue?
Re: Dealing with BAD Data in SSIS - 07-06-2010 , 05:52 AM
to solve this in SSIS
- import as strings
- cast to date and redirect error rows
there are ways to fix this in SQL (the source statement) if you need better
performance, but easier is usually better...
hope this helps
"robboll" <robboll (AT) hotmail (DOT) com> wrote
Re: Dealing with BAD Data in SSIS - 07-14-2010 , 09:37 AM
did you use cast in the sql query ?
Please check the data type.
or you can give a default value (TO_DATE()) for this column.
"robboll" <robboll (AT) hotmail (DOT) com> 写入消息
news:c9733942-16f3-4a32-83e7-1585d9f8022e (AT) d16g2000yqb (DOT) googlegroups.com...