DTS Export Questions -- sql server dts

Allan Mitchell
9/7/2005 12:00:00 AM

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

[quoted text, click to view]

DaveM
9/7/2005 10:11:03 AM

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,

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 about sql server dts

sql server dts : DTS Export Questions