Thanks Sean,

To be honest, Im not happy about this bridging approach at all, but Im not sure what else to do. The foreign key linked tables have relationships that are...

Sorry Derrick,

I had a mistake in my example (Late night).

The schema is customers, not orders, I have no periods in the table name

So, tablename is auditdb.customers.ordersaudit (where customers is the...

Use enterprise library where?...

Thanks Gift,

So you would recommend only using the presentation layer (report manager and WS) and the DB layer. Problem is the infrastructure folks are unhappy about direct connections between the...

I posted on msdn and got this solution

http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/38016fd9-4a7d-48d5-850b-dc01e370f3af

Thanks for this solution. This works fine against tables. How would I go about this if each set of elements were created from a SQL statement involving joins?

Apologies. As my question follows the context of this existing thread, I assumed that appending to the thread would be preferable to proliferating similar threads.

Thanks for the XML tag tip.

Can...

Folks, I want to generate XML for a basic structure where there is several differing element types listed within the root with no relationships.

Say I have products, customers and...

Thanks Steve,

My solution was to use stored procedures to pull each xml section and return a table variable with the required data and format.

Running into the problem you mentioned with varchar(max)fields/blobs

[XML Destination [1112]] Error: System.InvalidCastException: Xml type 'List of xdt:untypedAtomic' does not support a conversion from Clr type 'BlobColumn' to Clr type 'String'.

I...

Steve,

Thanks for providing the example. You inspired me to try this on another machine and it worked. Must have had a "ghost" version of the control in the toolbox.

Thank...

Thanks Steve,

Any chance you send me a screenshot of the dataflow?

Just so I know Im not going mad, will you try using two oledb sources to do the same?

Cheers

Mick

Folks,

The SSIS XML destination control proclaims that it can

Support multiple inputs on a single component

I have not been able to get this to work. If I add more than...

Steve mate, Im intrigued, can you elaborate a bit? Not that versed in SSIS.

Were you able to implement the relationships within the XML structures when you merged it together?

Cheers

Mick