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-07-16 : 10:47:53
|
| Dear all,i am loading the data from source (ORACLE ) TO Destination(Sql server) one of my source field is existed like this format1900-01-01 00:00:00.00000001900-01-01 00:00:00.00000001900-01-01 00:00:00.00000001967-02-22 00:00:00.00000001960-02-24 00:00:00.00000001983-04-25 00:00:00.0000000when i loading the data data i got the data conversation overflown issuei resolved the issue using Advance editor properties field i has changed (databasetimestamp with precison[DT_DATATIMESTAMP2] TO database timestamp[DT_DBTIMESTAMP]) database time format (i have loaded successfully)my table column is has existed datetime2(7)that column is showing for every Row is this format 2012-07-16 00:00:00.00000002012-07-16 00:00:00.00000002012-07-16 00:00:00.00000002012-07-16 00:00:00.0000000which way i have to move the data from source to destination without interrupts |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-16 : 11:24:00
|
| You could convert that to a date, smalldatetime or datetime.The problem with oracle to sql server dates is that oracle can store older dates than sql server.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
datetimeformat from orcle to sql server