sql server dts: DTS Error -- sql server dts

DTS Error

XXX
9/28/2005 12:16:26 PM

sql server dts:

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!

Re: DTS Error

Allan Mitchell
9/28/2005 5:35:46 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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.