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 |
|
pwvailla
Starting Member
31 Posts |
 Posted - 2010-11-19 : 13:37:00
|
Hi,I am tryin gto IMPORT data from an Oracle database, 3 of the 4 table import fine and I can pull million plus rows of data. One table blows up because of a DATE field, RECV_DATE(345) on input "Destination Input" (224). The column status returned was: "conversion failed because the data value overflowed the specified type". It is a date field going into a date field....1. I am using SQL Server 2005, Std Ed. Are there TRANSFORMATION abilities in the Enterprise Edition? I see reference to them, but they are not available in the Std Edition? Is this true?2. How do you address these problems is you can't get at the source data to correct it? I can view the data with Oracle tools just fine...Thanks  |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-11-19 : 13:51:22
|
| SQL Server only allows dates >= '17530101', if Oracle allows dates like '12311231', SQL can't convert it (our DB2 has a date field that allows that and we use it as a default). SSIS does have a transform component, and you can also use t-SQL :CASE WHEN isdate(RECV_DATE)= 1 THEN RECV_DATE ELSE NULL ENDJimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
Dealing with IMPORT errors - Invalid character val