Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottjohniec
Starting Member
7 Posts |
 Posted - 2006-03-07 : 12:47:27
|
| I've been working with some Databases that come off the Main Host of an AS400. The files I need to work with have birthdates such as 2/29/03 (Which isn't a Leap Year), and just invalid dates all around. When I execute the DTS Package it's connecting to the Host via an OBDC Connection. It starts the download routine and once it hits one of these dates,I get a generic error message "Invalid Date". It doesn't give me a hint on what the record is or anything. I have to execute a bunch of queries to locate Months > 12,, Days >31, etc.Is there some way to ignore these bad dates or does SQL say NO WAY !I don't have access to these records other than "Read Only" or I would fix them without building logic around them to ignore bad dates of xx/xx/xx.Thanks ! |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-03-07 : 12:50:43
|
| Can you first import them into a VARCHAR field in a staging table, then perform the conversion employing an ISDATE test.Mark |
 |
|
|
|
|
|
Getting Invalid Date Errors When Importing Data