Flat File Schema Custom Date/Time Property

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Phil Knight (PhilKnight_at_discussions.microsoft.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 06:35:02 -0800

Can somebody tell me if the Custom Date/Time Format property of a flat file
schema is only used when parsing an input flat file?

I have tried adding the property to a schema used in a flat file assembler
component of a send pipeline, but the setting appears to be ignored. Do I
have to change the data type in my output schema to string and use a functoid
to do the conversion instead?

Phil

Relevant Pages

  • RE: Optional Field essue.
    ... Is it possible to have duplicate tags in the Flat file ... case in schema level. ... When I use input with missing one or two of those optional records then the ... If i miss H03 or D01 in my input flat file, then my xml out put is created ...
    (microsoft.public.biztalk.general)
  • RE: root element missing
    ... I get this error when trying to test my schema with an input flat file ... schema and edit it slightly and then test this as input and no problems. ... Can you shed some light on how BizTalk identifies the root element ...
    (microsoft.public.biztalk.general)
  • RE: Creating Schema for Flat File Disassembler
    ... I restructured you schema a bit and it will now parse your input data. ... main problem with your original schema was setting the positional offset ... Creating Schema for Flat File Disassembler ...
    (microsoft.public.biztalk.general)
  • RE: Flat File Issue with Multiple Line Flat File
    ... I restructured you schema a bit and it will now parse your input data. ... main problem with your original schema was setting the positional offset ... Flat File Issue with Multiple Line Flat File ...
    (microsoft.public.biztalk.general)
  • RE: Schema for output flat file
    ... It's difficult to know exactly how to describe your schema without being ... Schema for output flat file ... Each record type have 64 byte. ... >>>>My flat file has layout as below:>>FHeader a b c d SMHeader e f g h SMDetail i j k l SMDetail m n o p>>SMDetail q r s t SMTrailer u x y w SMHeader a b c d SMDetail e f g h>>SMDetail k q r sh SMDetail q r s w SMTrailer o p w s FTrailer h g w s>>>>I know know how to define send schema to output flat file as above. ...
    (microsoft.public.biztalk.general)