Error loading Oracle DATE data

Hot Topic

SQLEVN70.rll error
Reporting Services 2005 xml datasource
Problem formatting currency to different decimal places
SQL Server 2005 stdevp function
Problem with SQLAgent Running SSIS Package "...package execution failed..."
Hyperlink report in new page..Urgent
Cant Install ReportBuilder The remote server returned an error: (401) Unauthorized.
32bit Admin tools when the only media you have is 64 bit
Data Comparison Question
Report model data sources

SQL Server

beginner
Moving SQL 7 DB to different machine SQL2000
Security levels of CLR code when deployed to another server.
SSIS job cannot find file....
SQL DataReader Mischief ! HELP !
FTP Task issue
SSIS - Handling different types of record in same flat file source
2005 CTP Connection error
How do a make a bulleted list.
Problem with parameterized query.

Error loading Oracle DATE data

Hello.

I'm trying to put in an SQL server database some data extracted from Oracle Server 9i.

During the load process, the "OLE DB Destination" in the task chokes up when it finds a record containing the date '0197-01-01 00:00:00' (i got this by putting the error output to a column of type varchar(50)). I can't use the Condicional Split's date functions to filter this out because they also choke on the strange date.

Can anyone give a sugestion

Thanks in advance,

Hugo Oliveira




Answer this question

Error loading Oracle DATE data

  • Snoo68

    You could treat the value as a string, test it to see if its a valid date and if it is is, cast it as a date.

    Those that are not a valid date - its up to you what you do with them. You could discard them or replace the value with a default.

    -Jamie



  • Chris Aus

    SQL will not recognize that as a date. Valid ranges for a datetime column are January 1, 1753, through December 31, 9999. If you want to filter it out use the error output like you're doing.

  • oprasad79

    Hello Brent.

    I gess the error output is the only solution. Just wondering if there was another one.

    Thanks,

    Hugo Oliveira



  • Error loading Oracle DATE data
Answer this question