Hello,

I have two questions:
1. Source field is a varchar(4000), the destination is a TXT file, only
getting first 255 bytes of data. Can this be corrected?

2. Long field contains XML string, what is the best way to parse this? I
could write a script, want to avoid the development.

Thanks in advance,
Dave

The 255 thing might be answered by this

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


Parsing XML would really be done in an Active Script transform or you
could write a custom transform (C++)

Allan

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