Is there a way to translate the packagedata field data to XML on the sysdtspackages90 table on msdb?
I want to be able to programmatically analyze and potentially modify the XML of Integration Services packages that reside on the server.
Thanks for your help.
Modifying the xml directly is not supported. However, you can get the package from the packages table by using the LoadPackageFromSQLServer method on the application object. You can save it to a file and then read the package file however you like to access the xml (xmlreader, dom, etc).
Matt
