How do I change the XSD-schema that should be used to generate the
XML-document in BizTalk2004?

[ Post a follow-up to this message ]

I'm not sure I understand your question. If you want to revise a deployed
schema you must undeploy the existing schema and deploy the revised schema
(in your compiled assembly).

If this doesn't answer your question please explain exactly what you are
trying to accomplish and I'll give it another try.

--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/



"newbie" <newbie@discussions.microsoft.com> wrote in message
news:3FB83557-93BB-4F40-B595-C9DA929F62A9@microsoft.com...
> How do I change the XSD-schema that should be used to generate the
> XML-document in BizTalk2004?

[ Post a follow-up to this message ]

Ok here is what I am trying to do. I have a XSD Schema already created. I
need to use this schema to generate an XML document from data in SQL Server
2000. How do I link an XSD Schema to a stored procedure, or something else t
o
plug in my data to generate an XML file through BizTalk 2004?

At the moment I'm using Add->Add Generated Items->...Add Adapter Wizard
select SQL->...Enter Target namespace:xxx and Input root element
name:xxx...->etc. But the XML-file created does not have the format I want i
t
to have, which I can understand.

I've created a XSD-schema out of a XML-document that has the format I want
and that I want BizTalk to produce, but I don't know how to use that
XSD-schema instead?

Does it make sense?

[ Post a follow-up to this message ]

The SQL Adapter is setup to generate the schema it requires. You can use the
SQL Adapter Wizard to create a schema to extract the required data from your
database and then map the resultant schema to your desired schema.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/



"newbie" <newbie@discussions.microsoft.com> wrote in message
news:7E0F4149-D442-4C5A-A396-F3735961F083@microsoft.com...
> Ok here is what I am trying to do. I have a XSD Schema already created. I
> need to use this schema to generate an XML document from data in SQL
> Server
> 2000. How do I link an XSD Schema to a stored procedure, or something else
> to
> plug in my data to generate an XML file through BizTalk 2004?
>
> At the moment I'm using Add->Add Generated Items->...Add Adapter Wizard
> select SQL->...Enter Target namespace:xxx and Input root element
> name:xxx...->etc. But the XML-file created does not have the format I want
> it
> to have, which I can understand.
>
> I've created a XSD-schema out of a XML-document that has the format I want
> and that I want BizTalk to produce, but I don't know how to use that
> XSD-schema instead?
>
> Does it make sense?
>

[ Post a follow-up to this message ]