Hey All - I've just been assigned the task of reading in an EDI 811 feed from one of our clients, and this is something we/I have never done before. Basically, the process that will handle these feeds from start to finish (reading them in to creating the invoices and reporting), is being created from scratch. I have a few options I've come up with so far on the route I believe I'll be taking to accomplish this task, but I was just curious if anyone else has been assigned something similar and/or if anyone has heard of any pricing estimates for a system like this?
A little background on the EDI 811 format:
1) File contains three main parts - Heading Area, Detail Area, Summary Area
2) Each of these segments can contain various information from multiple tables
3) Simply put, it is a bunch of relational database tables extracted into a flat file
I'm mainly going to be utilizing SSIS, T-SQL, UDF's and SProcs, and a little VB and PowerShell scripting to complete the lifecycle of this EDI reading process. Does anyone know what a fair price would be for implementing a Bill Reader system such as this from the ground up (i.e. reading in file, normalizing to standard format, consolidating invoices for auditing, reporting on invoices)?
Thanks in advance!
Danny SheridanComtekh, Inc.