BizTalk Server General - Flat File Output

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > March 2004 > Flat File Output





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Flat File Output
Jeff Dillon

2004-03-03, 4:37 pm

Does Biztalk support flat file output? We are importing flat files into SQL
Server, and need to output both XML and flat files.

Jeff


R.Balaji

2004-03-04, 4:35 am

Hi,
Yes.
You can generate flatfiles, EDI files and XML from biztalk.
Create an envelope in the BizTalk messaging manager.
Specify the envelope details in the Port configuration.
The BizTalk serializer will convert the XML into the specified file format
as given in the envelope.

Regards,
R.Balaji

"Jeff Dillon" <jeff@removeemergencyreporting.com> wrote in message
news:ur2FpXWAEHA.3940@TK2MSFTNGP11.phx.gbl...
> Does Biztalk support flat file output? We are importing flat files into

SQL
> Server, and need to output both XML and flat files.
>
> Jeff
>
>



Brian Loesgen

2004-03-04, 11:34 pm

Flat files are easier with BTS2004. You add the "flat file extension" in the
schema editor and it allows you to define a flat file (delimited,
positional, or a combination).

The coolest part is you can generate an instance, just as you can with an
XML doc, but if you set the instance type to native (instead of XML) it will
generate a flat file for you that conforms to your specification. Pretty
cool.

HTH,

Brian Loesgen
Neudesic

"R.Balaji" <rbalaji007@hotmail.com> wrote in message
news:edI7iZcAEHA.916@TK2MSFTNGP10.phx.gbl...
> Hi,
> Yes.
> You can generate flatfiles, EDI files and XML from biztalk.
> Create an envelope in the BizTalk messaging manager.
> Specify the envelope details in the Port configuration.
> The BizTalk serializer will convert the XML into the specified file format
> as given in the envelope.
>
> Regards,
> R.Balaji
>
> "Jeff Dillon" <jeff@removeemergencyreporting.com> wrote in message
> news:ur2FpXWAEHA.3940@TK2MSFTNGP11.phx.gbl...
> SQL
>
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com