- This topic has 2 replies, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Hi,
I am picking a flat file from a system which uses a certain format (say some x format like UTF-8, UTF-16). The requirement is to convert this file to UTF-8 format as my destination system to which I send the flat file understands only UTF-8.
For Conversion, do I need to use Schemas or can I do the conversion in the pipeline.
If I try to use a Flat file schema wizard, In the code page I dont find the required format .
Please help me out.
Thanks in advance.
Newbie.
-
I think you need to do this conversion inside a pipeline.
Tomas talks about this a lot. Check out http://www.winterdom.com. He has some samples on the site he posts in a blog post a while ago.
-
The flat file schema wizard allows you to select the codepage (encoding) of the source/target schema. If you don't find the exact one you expect, there are ways around it, fortunately. First, consider how the flat file disassembler recognizes the encoding of an incoming flat file:
http://www.winterdom.com/weblog/2005/09/08/SelectingTheEncodingUsedWhenParsingFlatFiles.aspx
Once you know that, it's easy to see how to tell it to use a given encoding to interpret an incoming file. If the usual spots don't list the encoding you want, chances are you might be able to use my FixEncoding pipeline component in the decoding stage of your receive pipeline to select a different encoding.
Finally, you need to understand how the FlatFile Assembler finds out the encoding to write the flat file into, for that, check here:
http://msdn2.microsoft.com/en-us/library/ms964120.aspx
Hope this helps!
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.