Hello all,
My next work package is to process some records from an ASCII text file, which will update SQL database tables.
The text file is a collection of different, fixed length, records identifiable by their first 7 characters.
eg.
0057SIDAZ9BAT250659799BATTERY, SECONDARY CEA00000010
0033IIR 34B 2241797U00036999999Z
0035CRR W653 9416643 H904 941664399
0035CSS F407 2526355 F407 745033999
0034CDQ O951 T407396PGEA0001000050
0101DUE011204293803071204 F214 991086325000000221REOBDFAS A22
So first trick is, how do I split this file up into is component pieces, ie all the 0057SID records grouped together, then the 0033IIR records etc etc.
Then I have to process the information in these records, comparing existing data in the database tables with the new data being introduced by this file.
Then finally update the database tables and produce reports of the changes made.
My burning question is, what's the best way to start this particular job.
There is no User intervention required, it's a purely background batch job. The only thing the User does is supply the text file.
I'm working with MS Visual Studio, ASP.NET 2000 and have Crystal V9 as a reporting tool.
I would be very grateful for a kick in the right direction.
Thanks