Architecture help for a flat file processing system
- From: Dinesh
- Date: Fri, 16 Jan 2009 03:58:45 -0800
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
.
- Follow-Ups:
- Prev by Date: Re: dtasp_PurgeTrackingDatabase not removing Started ServiceInstances
- Next by Date: solution for flat file processing
- Previous by thread: Sqladapter error threshold - recommended setting
- Next by thread: RE: Architecture help for a flat file processing system
- Index(es):
Relevant Pages
|