I want to send a XML-fil (including data fetched form a table on a SQL
DB-server) to an FTP-server via BizTalk 2004. The XML-file should be
generated in a specific format.

Today I can fetch the data from the database table and send it as a XML-file
to the  FTP-server via BizTalk. The problem is that I'm not sure how to
generate the XML-file and make it the way I want it to look like? What are
the steps to accomplish that?

I've a .XSD-fil, which I suppose should be used to validate the generated
XML-fil.

Any help would be greatly appreciated!!!

[ Post a follow-up to this message ]

Hi

In that case if you want to have a different XML file with a different
schema to the FTP site, one way is to use a map to map the SQL adapter
schema that you use for getting to the data out of the SQL server to the
desired schema.

Thanks.

Basil Cheng
Microsoft Biztalk Developer Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

--------------------[vbcol=seagreen] 
XML-file[vbcol=seagreen] 
are[vbcol=seagreen] 

[ Post a follow-up to this message ]

Ok here is what I am trying to do. I have an XSD Schema already created. I
need to use this schema to generate an XML document from data in SQL Server
2000. Is anyone familiar with how to link an XSD Schema to either a stored
procedure, or a query to plug in my data to generate an XML file through
BizTalk 2004?


"Basil Cheng (MS)" wrote:

> Hi
>
> In that case if you want to have a different XML file with a different
> schema to the FTP site, one way is to use a map to map the SQL adapter
> schema that you use for getting to the data out of the SQL server to the
> desired schema.
>
> Thanks.
>
> Basil Cheng
> Microsoft Biztalk Developer Support
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> -------------------- 
> XML-file 
> are 
>
>

[ Post a follow-up to this message ]

You can configure a SQL Receive Adapter to return XML data using the "FOR
XML AUTO", "FOR XML AUTO, DATA", and "FOR XML AUTO, XMLDATA" supported SQL
clauses.  Once you extract this data from the DB in XML form, you can map
this output schema to your own pre-existing XSD.

See "SQL Receive Adapter" in the BizTalk documentation, available online
here:
http://msdn.microsoft.com/library/d...pt_sql_esig.asp

HTH,
Doug

This posting is provided "AS IS" with no warranties, and confers no rights.


"newbie" <newbie@discussions.microsoft.com> wrote in message
news:29FD9043-8AB8-42F1-B997-20C0D20206B1@microsoft.com...
> Ok here is what I am trying to do. I have an XSD Schema already created. I
> need to use this schema to generate an XML document from data in SQL
Server[vbcol=seagreen]
> 2000. Is anyone familiar with how to link an XSD Schema to either a stored
> procedure, or a query to plug in my data to generate an XML file through
> BizTalk 2004?
>
>
> "Basil Cheng (MS)" wrote:
> 
to[vbcol=seagreen] 
generated[vbcol=seagreen] 

[ Post a follow-up to this message ]