February 18, 2009 at 8:29 am
Hi guys,
I'm having a bit of a mare with a problem that I don't understand. Maybe you can put me out of my misery!
I've got two boxes running SQL 2000 sp3a. There's a DTS setup which takes data from box1 and, through a data transform, dumps it into a table on box2.
The table on box2 is an exact copy of the table in box1 that the data is being extracted from. However, the first column appears to have one character truncated off of the end. There's nothing in the query that would cause this and the column in question is the same data type etc as the source column.
Has anyone seen this before or have any idea what's wrong?
Also - what other information (if any) would be useful?
Many thanks!
Iain
February 18, 2009 at 9:26 am
Can you show some sample data?
Is it always one character in every row or just some of them? Any pattern you can discern?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply