MS SQL Server DTS - DTS Error

Author

DTS Error

XXX

2005-09-28, 11:24 am

I have a DTS package which copies rows from 150 tables using Union ALL.
Around 30 million rows are involved. However package fails after 8.6 million
ros with the error
Error at Source for Row number 8697091. Cannot convert nvarchar value of
(NULL) to tinyint. Errors encountered so far in this task: 1.

Now I have no way of knowing what this row is and also my destination table
does have a tinyint. Please help!

Allan Mitchell

2005-09-28, 1:23 pm

OK so you say you have a tinyint column in your destination. Can you
not check the source query and ask the question "What data in here is
not numeric or is > the max limit for the tinyint datatype or even < the
value for the tinyint datatype?"

Allan

"XXX" <sa@nomail.com> wrote in message
news:OayS#fExFHA.2932@TK2MSFTNGP10.phx.gbl:

> I have a DTS package which copies rows from 150 tables using Union ALL.
> Around 30 million rows are involved. However package fails after 8.6 million
> ros with the error
> Error at Source for Row number 8697091. Cannot convert nvarchar value of
> (NULL) to tinyint. Errors encountered so far in this task: 1.
>
> Now I have no way of knowing what this row is and also my destination table
> does have a tinyint. Please help!

Sponsored Links