Hello,

We are facing the following error when we try to import
data from Pervasive SQL 2000 database server to MSSQL
server 7.0.
The source table in Pervasive contains a field with
datatype 'notes'. We have the corresponding SQL table with
field data type 'text'. 'ADDL_INFO' is the field name.

Error Message:
"General Error -2147217887 (80040e21). Cannot Instantiate
Storage Object for source column 14 'ADDL_INFO' Blob data.
Multiple-step OLE DB operation generated errors.Check each
OLE DB status value, if available. No work was done."

Please help.

Thanks
Ebron

This looks likely to be an OLE DB Provider problem, are you using an OLE DB
provider or an ODBC Driver for pervasive? Whichever you are using try the
other one, it may be slower but more functional. It also looks like there is
a table with a type of text/blob in one of the transforms, try moving the
data without this column for testing purposes.

--
-Euan

Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.

This posting is provided "AS IS" with no warranties, and confers no rights.

"Ebron" <ebron2 (AT) yahoo (DOT) com> wrote

Euan,
Thanks for your help.

Actually we use ODBC driver for pervasive. And now, we
tried using OLE DB provider, but it is unexpectedly very
slow. So we are not able to find whether the error is
fixed or not.

Ebron

Did you try removing the blob column and see how that worked in DTS? In
addition there is a limitation in Kagera(OLE DB for ODBC) that means that
any blob column must always be the last one in the column list.

--
-Euan

Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.

This posting is provided "AS IS" with no warranties, and confers no rights.

"Ebron" <ebron2 (AT) yahoo (DOT) com> wrote