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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-05-18 : 09:14:14
|
| I WANT to move the data from oracle to sql server using dataflowtaskone of my table column(dateformat existed like this way1998-11-27 00:00:00.0000000when i connected bussiness intelligence studio oracle ---->sql staging (db)when executed dataflow task i got this error conversation failed because of the data value overflowned by specifed datatypeafter thati have used data conversation Transformation oracle -->dataconversation--->sql staging (db)same error getting pls help me |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-18 : 09:43:30
|
| In order to maintain that datetime precision you'll need to import to a datetime2(7) column. Or you'll need to trim the value to only keep milliseconds if you're importing to datetime. |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2012-06-01 : 08:04:59
|
| I HAVE CHANGED MY TABLE DATATYPE IS DATETIME2(7) ITS WORKING PROPERLYThanksmohan |
|
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2012-06-19 : 02:22:39
|
| dear all they have changed my source column like this way 2012-06-18 05:09:29.0000000once again i am getting the sameerror[OLE DB Destination [31]] Error: There was an error with input column "EVENT_TIME" (56) on input "OLE DB Destination Input" (44). The column status returned was: "Conversion failed because the data value overflowed the specified type.".any body know exlain me |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-06-19 : 06:31:56
|
| IIRC Oracle datetime can store BCE dates that SQL Server doesn't support. I suggest you check your data for any dates prior to Jan 1 0000, you'll have to filter them out or change them to another value that SQL Server supports. |
|
|
|
|
|
|
SSIS 2008 R2(dataconversation OVERFLOWN)