|
Home > Archive > BizTalk Server General > November 2005 > Delimited Flat File Schema
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 |
Delimited Flat File Schema
|
|
| Ryan G. 2005-11-21, 8:48 pm |
| Hello,
I am not that advanced in the flat file schema creation world as i have
had the luxury of working with pure XML over the last several years.
I currently have a flat file schema with a root node. The root is set
as pipe delimited. The root has a child record (child) that is set as
positional and which contains all the data elements.
There are several elements at the end of each child record that are
often blank when output from the sending application.
There is one element in that group that when blank signals that all the
rest of the elements are going to be blank. if it is, the row
delimeter should appear instead and all following empty elements should
be ignored.
Is this something i can set at the flat file schema level? If so, what
setting am i looking for?
Thank you in advance for you help,
Ryan G.
| |
|
|
| Jeff Lynch 2005-11-22, 2:48 am |
| Ryan,
If you post a sample of your flat-file at microsoft.public.biztalk.nonxml
there are several flat-file experts (Dave Downing [MSFT]) that can help. I'd
be glad to take a look also. Unfortunately, I've had a lot of flat-file
experience.
--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch
"Ryan G." <ryan.garner@gmail.com> wrote in message
news:1132620494.491604.10820@g47g2000cwa.googlegroups.com...
> Hello,
>
> I am not that advanced in the flat file schema creation world as i have
> had the luxury of working with pure XML over the last several years.
>
> I currently have a flat file schema with a root node. The root is set
> as pipe delimited. The root has a child record (child) that is set as
> positional and which contains all the data elements.
>
> There are several elements at the end of each child record that are
> often blank when output from the sending application.
>
> There is one element in that group that when blank signals that all the
> rest of the elements are going to be blank. if it is, the row
> delimeter should appear instead and all following empty elements should
> be ignored.
>
> Is this something i can set at the flat file schema level? If so, what
> setting am i looking for?
>
> Thank you in advance for you help,
> Ryan G.
>
| |
|
|
|
|
|