|
|
Posted by Wes Groleau on 11/16/06 04:47
Dan Guzman wrote:
> You're right about the EDI to XML translator - I misread Wes's post. of
> course, SQLXML can't consume EDI directly.
Of course, I could easily write something to
convert it to XML that SQL server can read.
But then I could just as easily convert it
directly into INSERT statements. I'm just
wondering whether DTS or anything else is faster.
I already have a tool that loads the entire
file into an array of lines and provides various
query functions for other apps to access it.
But I'd like to put multiple files in the database
instead of having to select one file at a time.
By the way, whatever the technique is, it could
probably also handle GEDCOM files.
--
Wes Groleau
There ain't no right wing,
there ain't no left wing.
There's only you and me and we just disagree.
(apologies to Jim Krueger)
Navigation:
[Reply to this message]
|