I am having trouble creating one input flat file. Could you please some one help me to resolve my issues. Here is the sample layout of my records. I have different types of records such as 10,15,20,30,40,50,60 and 70, some of them are optional and may or may not be present and can occur more than one too. (All these records are same length but diffent layout for each records) And this set will repeat in my input file. Could you please help me to generate a flat file based on this kind of data ? One time I was getting Unexpected data found while looking for: $Delimited$ I changed my schema's default child order to Postfix/Infix and character type hexadecimal 0x0A 0x0D and both cases I am getting " Unexpected data found while looking for: '\n\r'" 10aaa1111bbbccc 15bbb2222xxxxxx 203333333qqq222 25tttttttttt333 50xxxx11112222x 50www22223333yy 10aaa1111bbbccc 15bbb2222xxxxxx 203333333qqq222 25tttttttttt333 50xxxx11112222x 60www22223333yy 70sss111133333q url:http://www.ureader.com/gp/1207-1.aspx
Hello, This is basically the only message the Flat File Disassembler gives you and I'm affraid it's not always the best. It looks to me what you want to do is define the schema to be Delimited, then define repeating records inside of it (each with a Tag Identifier). Then go and define each of these records themselves as Positional. Be sure to include their Tag Identifier so BizTalk can find them. Here's a good walk through article: http://www.winterdom.com/dev/bts/BTSFFSchemaTut2.html The Flat File stuff can be hard to get into in BizTalk, but once you do you'll never write code to do it again and it's easy, fast, and powerful. Kind Regards, -Dan
Hi, Dan's susggestion just addressed the problem. If you still cannot figure out the problem and the error persists, feel free to send a copy of your problematic schema and expected input file to me at: wjzhang@online.microsoft.com (please remove online.) I will look into it and help on turning up where the problem is. Have a nice day. Sincerely, WenJun Zhang Microsoft Online Community Support Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@microsoft.com. ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Hi, Just wonder if you still have any further question for this issue? Thanks. Sincerely, WenJun Zhang Microsoft Online Community Support Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@microsoft.com. ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
