sql server dts: I have table with 500 fields, each record has to be converted to one giant XML(48000 Characters) and update the filed called ISIRXMLDATA in the same table
Only 1/3 of concatenated nodes make it to the XML String
I wish to provide the solution as stored procedure and VBS, away from VB, The data is imported from a text file via a DTS, DTS recommendation with active X will work als

In message <B1DE69BB-29D0-4AEE-89F0-DAB24689774E@microsoft.com>, Siakzar
<its@ecommerce-one.com> writes
[quoted text, click to view]

Use an ActiveX Script Transformation script. As this works at a row
level, as part of the load you can build your XML document from teh
required source values and assign it to ISIRXMLDATA in teh destination
column collection, alongside all the normal columns.

When setting this up, make sure all columns are included in a single
transform, so the one script covers all columns. (This is faster anyway,
but obviously required here).

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org