Thanks for the advice, I'll give the Chameleon evaluation version a go.

> -----Original Message-----
> From: Mark Harr
> [mailto:mssqldba-ezmlmshield-x55118734.[Email address protected]
> Sent: 28 May 2004 00:06
> To: LazyDBA.com Discussion
> Subject: RE: HL7 message import
>
>
> Yes, you will need/want a 3rd party app to translate your HL7
> data. You
> can write your own, but handling the record sequences and variable
> fields is quite a pain. I have used Interfaceware's Chameleon in the
> past. While a bit pricy, it will save literally weeks of
> time trying to
> write a custom solution.
>
> =======================
> Mark Harr
>
>
> > -----Original Message-----
> > From: grea
> > [mailto:mssqldba-ezmlmshield-x45159894.[Email address protected]
> > Sent: Thursday, May 27, 2004 10:39 AM
> > To: LazyDBA.com Discussion
> > Subject: HL7 message import
> >
> > Hi folks,
> > I've got a MSSQL DB that I want to receive updates from an
> > Oracle DB via
> > TCP/IP Messaging (HL7). Anyone know how to get these messages
> > in? Do I need
> > 3rd party SW to listen for them?
> > Regards
> > Gab
> >
> >
> >
> **********************************************************************
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error
> please notify
> > the system manager.
> >
> > This footnote also confirms that this email message has
> been swept by
> > MIMEsweeper for the presence of computer viruses.
> >
> > NCHT
> >
> **********************************************************************
> >
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > Website : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> > For additional commands, e-mail: mssqldba-[Email address protected]
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

NCHT
**********************************************************************



MS Sql Server LazyDBA home page