Hi!
I am trying to import several tables from a Timberline
database into a SQL Server 2000 database using DTS. The tables import well, except when a table contains a blob (memo) 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". This field is really just an oversized text field. It's not a binary blob, just a text blob.
Can anyone point me to a discussion of this error anywhere? I've tried researching this error message on Microsoft's sites, but with no luck. They don't seem to have addressed this error and I can't figure out why. Any help would be reatly appreciated. I really need to know what's causing his error and how to resolve it. I have tried changing the datatype of the field in the destination table to "Varchar (3000)", which s more than enough characters to contain the text in this blob memo) field. Sometimes it seems to work, other times it eems to fail.
This is the second time I've posted this question. The first post got no response. I'm posting again because I can't seem to get any good answers anywhere else.
Thanks!
Karen Grube
kgrube@ffres.com
I am trying to import several tables from a Timberline
database into a SQL Server 2000 database using DTS. The tables import well, except when a table contains a blob (memo) 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". This field is really just an oversized text field. It's not a binary blob, just a text blob.
Can anyone point me to a discussion of this error anywhere? I've tried researching this error message on Microsoft's sites, but with no luck. They don't seem to have addressed this error and I can't figure out why. Any help would be reatly appreciated. I really need to know what's causing his error and how to resolve it. I have tried changing the datatype of the field in the destination table to "Varchar (3000)", which s more than enough characters to contain the text in this blob memo) field. Sometimes it seems to work, other times it eems to fail.
This is the second time I've posted this question. The first post got no response. I'm posting again because I can't seem to get any good answers anywhere else.
Thanks!
Karen Grube
kgrube@ffres.com