Hi!
I am trying to import several tables from a Timberline
database (which uses a version of pervasive sql) into a
SQL Server 2000 database using DTS. The tables import well, except when a table contains a blob (notes) field. When DTS
runs, the step (task) fails and I get an error message
that says "Cannot instantiate storage object for source
column" (column number, table name)" Blob data".
I know there can be problems importing large blob
fields using DTS, which is what I think I'm dealing with
here. Any suggestions? I need to be able to import these
tables on a daily basis.
Can anyone point me to a discussion of this error
anywhere? I've tried searching for this error message on microsoft's sites, but with no luck. Any help would be greatly appreciated.
Thanks!
Karen
I am trying to import several tables from a Timberline
database (which uses a version of pervasive sql) into a
SQL Server 2000 database using DTS. The tables import well, except when a table contains a blob (notes) field. When DTS
runs, the step (task) fails and I get an error message
that says "Cannot instantiate storage object for source
column" (column number, table name)" Blob data".
I know there can be problems importing large blob
fields using DTS, which is what I think I'm dealing with
here. Any suggestions? I need to be able to import these
tables on a daily basis.
Can anyone point me to a discussion of this error
anywhere? I've tried searching for this error message on microsoft's sites, but with no luck. Any help would be greatly appreciated.
Thanks!
Karen