EDI processing. (original) (raw)

I'm banging my head on the desk here.

I have a basic (very basic) EDI parser written in FoxPro. It works just fine, except that the file I'm supposed to be parsing now (new client, new file, natch) is 1.5 gigs. Even split into 10,000-record segments, it takes about a week. We don't have the time to wait for it to run, not to mention all the debugging time (it's not standard EDI, it's got a few quirks, so the program has already been extensively modified). I've spent about a month on this, and I really can't afford any more time.

Does anyone know of a book which covers programming an EDI parser in SQL Server 2000? The Amazon search function is useless, because when you dearch on "edi" you get all books with the word "edition" in the description-- which is, basically, all books on SQL Server 2000.

Failing that, does anyone know of a way to kludge an EDI parser in SQL? The FoxPro code is not translatable, as it uses functions that T-SQL doesn't have (e.g, scan...endscan). Getting them to convert the file to XML is not an option; they won't even break it up for us. Buying a third-party EDI parser for SQL and/or BizTalk Server is not an option because of the price. Basically, I'm stuck with no choice but to put it together myself, and I have no clue how to go about it when I don't have some of FoxPro's functions available to me.

Any suggestions? TIA.