May 12, 2005 at 10:16 pm
Hi All,
Need your expert advice on this. I am trying to extract data from oracle > MSSQL. The extraction was done using ODBC. It works for some tables except for one table which gave the following error as shown below.
-----------------------------------------------------------
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700
-----------------------------------------------------------
Note that the field definitions type extracted from the table which did not work were the same the those other tables that worked.
Does anyone know how to resolve this error?
Appreciate your assistance. =)
May 13, 2005 at 3:10 am
If the definitions reamin the same, take a look at the data inside. Possible this is causing you an error.
Try copying one column at a time until you find where the error is coming from.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply