I have a simple table with five columns. One of the column is a
date.

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
"00/00/0000"

Can anyone suggest a method of dealing with this issue?

Thank you!

RBollinger

Anyone familiar with RegexClean? I just imported the add-in
transformations to take care of these type of data issues.

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
Gorm

"robboll" <robboll (AT) hotmail (DOT) com> wrote

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...