OK what you are probably seeing is a restriction on the QA Tool itself

Go to

Tools | Options | Results

Now look for the "Maximum characters per column." Increase that to the
value you want


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"AJ" <AJ (AT) discussions (DOT) microsoft.com> wrote

I am using QA to view the results and do only see 255 characters. Thanks for
the info on it only displaying that many characters - makes sense. However,
in my database front end, I am concatenating these 3 notes fields together
into one note field (MBR_NOTES) that displays. In that display, I only see
the truncated data. For example, assume the three notes are (shortened for
readability):

NOTE1='This is what is stored in note 1'
NOTE2='And in note 2, this is what is stored'
NOTE3='Finally, in note 3, I have this'

My SQL is:
MBR_NOTES = NOTE1 + '**' + NOTE2 + '**' + NOTE3

I would expect to see:
This is what is stored in note 1***And in note 2, this is what is
stored***Finally, in note 3, I have this

Instead, I'm seeing:
This is what***And in note***Finally, in

"Allan Mitchell" wrote:

Oh I see so each attribute is being clipped before the joining

Do you know how long each piece of data is so

LEN(NOTE1)

There is this as well.

DataPump truncates delimited fields to 255 characters
(http://www.sqldts.com/default.aspx?297)


When you say TEXT fields you mean TEXT fields and not CHAR or VARCHAR right?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"AJ" <AJ (AT) discussions (DOT) microsoft.com> wrote