Can data be streamed to SQL.
We are a hospital. A patient is admitted to the hospital.
That admit goes to an interface engine as a record. The
interface then sends the record to other systems in an
format called HL7. I want this record to be sent to an
SQL server. This interface engine connects to tcp port.
Can I somehow monitor a port for activity and then create
insert, delete, updates from the record info sent to the
tcp port?

I know that DTS can make connections to files/other db
resource but can it do this?

What format is HL7 ? If it is a file and you can read it then DTS can use
it. Darren used to work in a hospital so he may already have done this kind
of thing.

Looking at this it would certainly seem possible

http://www.accent-ltd.com/1229/1252.html

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Chris" <cyoung (AT) medcentral (DOT) org> wrote