Shaira (8/29/2013)
Thanks for the link but it's still working one package at a time to get the information. Granted, once it's done you've got it, but for now I was just looking for a quickie method.Thanks for the posts!
Unfortunately there's no quickie for this one.
Once you have the XML query to extract the data you need, you can put it in a cursor to loop over all the packages and store the extracted info into a table.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP