XML and text encoding functionality?
We've currently been working with SSIS by using the xml functionality within in sql2005 combined with delivering XML encoded in non iso-8859-1 encoded files, and there is very little component support for this kind of integration scenario.
- We are basically forced to use script components for everything.
Are there any new functionality planed within the sql2008 version to include support for this common scenario
Are there any improvments to the handling om XML in SSIS in SQL2008?
Our wishlist whould include:
- handle xml as a native data-type in SSIS
- improved xml handling functions within control flow and Data Flow.
- encoding-conversion support mainly within destination components (file, web-service, etc)
Searching the web indicates that we're not alone struggling with this...
