HL7 is a formatting standard used in interfaces between disparate Medical systems.It's generally a realtime system whereby messages are fed through a middleware server via TCP/IP and then discarded, or at least archived very quickly. The message is formatted according to an agreed standard with pipes and ^ etc seperating fields.
I want to use it in a different way. The messages will be output as a batch file, which my process will read and then update an SQL Server database accordingly.
I have written stored procedures to be used as a datsource for Crystal, but not much else in SQL Server.
What is the best way to go here. Can this be done in DTS or is oSQL a better option. Of course it will need to be scheduled, with logging etc. Is XML an option ?
Thanks
I want to use it in a different way. The messages will be output as a batch file, which my process will read and then update an SQL Server database accordingly.
I have written stored procedures to be used as a datsource for Crystal, but not much else in SQL Server.
What is the best way to go here. Can this be done in DTS or is oSQL a better option. Of course it will need to be scheduled, with logging etc. Is XML an option ?
Thanks