Hello All,
I have DTS Pkg that generate a result table. I need to output a few attributes from the result table out to a file in an XML format. For example, cust_id, first_N, Last_N, D_Date,Type. Can you please give me guideline of how to accomplish this. What connection do I need to creation for the destination file within the DTS Pkg and what xml syntax do i need in the select statement to retrieve the data from the result table. Your help/suggestion is greatly appreciated.