greetings, is there a way to import cXML data and also to generate cXML data using SSIS Package? If anyone could kindly guide me to right direction will be much appreciated. Thank you.

As there is no xml Destination in SSIS , you can use Script Component as Destination. ( I think cXML has a format like xml ) there are also third party tools which you can find with "xml destination in ssis" googling. http://www.rad.pasfu.com

You may want to try and alter Simon Sabin's XML Source Script. Talk to me now on

Thank you guys. I will try the link provided by Todd.