solution for flat file processing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I am trying to develop the high level of architecture of a system to process flat files.

Briefly the system is like this.

Files are sent from an external system to a specified location in our file system. These files has to then go through what is called a primary validation where data is checked for consistency, length header etc.
If errors are reported they are to be recorded in a database. if primary validation passes, then a seconday validation runs which validates each of the data in these flat files against variuos master databses.As in the case of primary validation, erros are to be recored in a DB and if every thing else goes fine, then they are forwared to another system.

Ehat would be the best technology to implement solution for this kind of problem. Biztalk, Windows work folw or SSIS or any thig else.

Thanks in advance


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng
.

Relevant Pages

  • Architecture help for a flat file processing system
    ... I am trying to develop the high level of architecture of a system to process flat files. ... Ehat would be the best technology to implement solution for this kind of problem. ...
    (microsoft.public.biztalk.general)
  • Another flaw in C?
    ... [It would be more in the "spirit" of C, rah rah, and more mathematical ... correctness on the target architecture. ... detects what sort of machine is running? ... given its overblown claims to be BOTH low and high level, ...
    (comp.programming)
  • High Level Architecture for Social Networking Platform
    ... I'm in a first design phase and I should choose an high level ... I also looked at the architecture of some "white label social ... concers more related to the "social aspect" of the platform (i.e. ...
    (comp.software.patterns)
  • Architecture Overview
    ... Can anyone point me in the right direction for an high level ... architecture overview of how a typical smart card system would look/ ...
    (comp.arch.embedded)