Hi all,
I'm getting an error when running a simple dts package created through the
import/export wizard. It's only happening on 9 tables out of 50. The tables
that error out do have the TEXTIMAGE_ON [PRIMARY] but when I take if off the
target table I still get the error. The error is below. ANy help would be
appreciated.

"The number of rows exceeded the maximum specified. Unspecified Error"

There's no specific error other than the one below. I tested further though
when I remove a few of the [text] data type columns the package runs! I can
manually insert the data through tsql but it fails in dts. Is there a buffer
or memory threshold that's being blown? It's really not a lot of data.

-THanks again! -Dave

It now seems that when
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

What is the error?

The message you posted means that the amount of error experienced exceed
the amount you allow.



"dfate" <dfate2001-rock (AT) yahoo (DOT) com> wrote

So it inserts it sometimes and others not.

One thing to try may be to specify the columns in the DataPump
SourceSQLStatement and make sure the TEXT column is at the end.

Allan

"dfate" <dfate2001-rock (AT) yahoo (DOT) com> wrote