>Do you push into your tables as each segment is read, or do you get all the segments first?
>
>UPDATE: And how do you handle multiple messages in one file? Each MSH is the beginning of a new message and you loop accordingly?
>


SNIP...

Depends on your business requirements. In our LOB, we must import the entire file in one database transaction. We might have as many as 2000 transactions (messages) in a single file.

What happens if you have a run-time error during parsing? How easy is it to recover? Can the client resend a partial file? These some of the things to consider.