Repost - XML Complex types as xml data sources

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Dot NoSpam - 16 Jun 2006 14:27 GMT

Repost from 6/13 since I've had no bites on it.

I'm automating data mart population using Visio as a data source. The first
step of this undertaking is to translate the visio diagrams into XML
equivalent. I defined a schema around this xml structure and of course, it
contains complex types. The XML data source transform does not consume
complex types.

Can the XML transform only consume really really simple XML? Can it handle
a .NET dataset? Will we ever have world peace? (ok, ignore that one).

Thanks.

-T

Reply to this Message

Kent Tegels - 16 Jun 2006 20:39 GMT

Hello Tim,

> Can the XML transform only consume really really simple XML? Can it
> handle a .NET dataset? Will we ever have world peace? (ok, ignore
> that one).

I'm researching this one on my first flight. I'll let you know what I come
up with.

Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/

Reply to this Message

Kent Tegels - 17 Jun 2006 01:00 GMT

Hello Tim,

> Can the XML transform only consume really really simple XML? Can it
> handle a .NET dataset? Will we ever have world peace? (ok, ignore
> that one).

I tried using an XML Source with a complex type where the data of interest
is represented in attributes. It did not seem to parse that correctly. Is
that similar to the problem you've run into?

Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/

Reply to this Message

Tim Dot NoSpam - 19 Jun 2006 11:15 GMT

Hi Kent.

Not exactly. When I supply the schema for the xml document, SSIS complains
that it cannot consume a document with complex types.

-Tim

> Hello Tim,
>
[quoted text clipped - 9 lines]
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/

Reply to this Message

Tim Dot NoSpam - 19 Jun 2006 11:28 GMT

Am I paranoid or what?

I am big proponent of "use the correct tool for the job" therefore, other
XML document consumers that are more suited for workflow should be used for
workflow, but is there a remote possibility that complex XML documents
cannot be consumed because there are already other products out there that
do this? (Biztalk) I realize that the consumption of complex types is only
a small part of the Biztalk product, but if I put my marketing hat on, it
seems to make sense to me.

-T

> Repost from 6/13 since I've had no bites on it.
>
[quoted text clipped - 11 lines]
>
> -T

Reply to this Message