none
Flat file validation

    Question

  • Hi All,

    I want to validate the incoming flat file in biztalk. suppose my flat file looks like below :

    ID,NAME,AGE,LOCATION

    1,ABC,18,IND

    2,DEF,20,US

    3,XYZ,23,IND

    If The above file will come come then everything will be ok, But now suppose there is something wrong with the file like below

    ID,NAME,AGE,LOCATION

    1,ABC,18,IND

    2,DEF,20,US

    3,23,IND ----In this record NAME is missing.

    in this case system will throw an error because file is not according to format. 

    But here is the case what i want. In this case i want to process the file without any issue. is there any way to do this?

    If am right then there is no out of box facility available in biztalk to handle this situation.

    thanks in advance

    Monday, February 20, 2017 6:25 AM

Answers