Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Flat File Source only brings in one row
- This topic has 9 replies, 1 voice, and was last updated 9 years, 1 month ago by
community-content.
-
AuthorPosts
-
-
August 2, 2006 at 3:19 PM #15178
Hi,
I am new to this BizTalk system. This is my first project and I am finding it very difficult to find any good documentation on the system.
I have a flat file comma delim file. I created a project to take a subset of those columns and map them to another file of pipe | delim. All works, except it only brings in the first row. Never brings in another row. How do I get the system to loop/process the whole file?
Thanks
-
August 2, 2006 at 7:58 PM #15179
I changed it to unbounded and still only brings in one row. I will try to create a new schema using the wizard and see if that works.
-
August 2, 2006 at 8:14 PM #15180
I also ran the wizard.. same issue.
-
August 2, 2006 at 8:31 PM #15181
I used the wizard on the flat file input. Change the export to unbounded. That now allows for multiple record processing but shows up like this…
ted|tom|mary|smith|rodgers|hays
vs
Ted|Smith
Tom|Rogers
Mary|HaysWhy is it processing all one element first then the next element second?
-
August 2, 2006 at 8:31 PM #15182
I used the wizard on the flat file input. Change the export to unbounded. That now allows for multiple record processing but shows up like this…
ted|tom|mary|smith|rodgers|hays
vs
Ted|Smith
Tom|Rogers
Mary|HaysWhy is it processing all one element first then the next element second?
-
August 3, 2006 at 1:46 PM #15183
Thanks… those helped. It was the cr/lf was in the wrong place on the output file.
-
August 3, 2006 at 7:24 PM #15184
I face the same like you had. When you said you change the export to unbounded, what note that you make change to unbounded?
Thanks.
-
August 7, 2006 at 1:49 PM #15185
I did as codecola said..
Set your root node (not <Schema> node) Group Max Occurs property to \”unbounded\” (u will find this in the Advanced section).
-
August 2, 2006 at 7:39 PM #15186
Set your root node (not <Schema> node) Group Max Occurs property to \”unbounded\” (u will find this in the Advanced section).
Why dont you use the FF Schema Wizard?
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bts06developing/html/a5e1453f-0380-4505-97a9-9d3526db0923.asp[/url]-
August 2, 2006 at 11:12 PM #15187
Something wrong with your delimiters and child order. You mut understand the properties of the Flat File section of your schema. Try to to read up Flat File schemas to understand the concepts first then jump to it.
here are some good tutorials
http://www.winterdom.com/dev/bts/BTSFFSchemaTut1.html
http://geekswithblogs.net/synboogaloo/archive/2005/04/22/37294.aspx
-
-
-
-
-
-
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.