Hi all,<br>I am having a problem pumping data from and oracle8 database to sql server. The table in question has 9000 rows in the oracle database. The import runs to row 6537 and then comes up with the following error:<br>"insert error column51 ('sale_date',DBTYPE_DBTIMESTAMP), status 6 : data overflow"<br>I have looked at that row in the oracle table and there doesn't seem to be anything unusual about the date in there. This problem is happening in a number of tables. For other tables the date fields import no prolem!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle8 to SQL Server7 DTS export problem
- Thread starter mfd777
- Start date
- Status
Similar threads
- Locked
- Question
- Question
