In my incoming third-party XML, how do I change the Attribute to be an element?
That way, instead of reading this:
it will be readable as this:
I saw snippets about how to use XSLT to do this kind of work. Is it possible to do this using SSIS?
Something like the following would work in SQL Server, but I don't think it is the right tool for the job. An XSLT would probably be much better but, since this is a SQL Server Q&A board, let's go with that:
As for SSIS, you can do pretty much anything with a .NET Script Task...
answered Apr 13 '11 at 06:58 PM
I used XSLT and solved this problem
answered Sep 01 '11 at 02:05 PM