Re: XML INTO SQL

KEN (kenkopicky@xxxxxxxxx) writes:
I Started by writing a ActiveX data transformation object I thought a
stored procedure might be better because I can call it when the xml
file hits our server rather than scheduling it because the file name
will change. Would you mind posting the code for a good Active X
solution the link you referenced got truncated.

Did I even reference a link? My VBscript abilities are not fantastic, so
I will have to decline. I just pointed out the possibility.

But when you ask "when the files hits the server" I have to ask: how you
detect that this occurs? Surely not through a stored procedure? Why cannot
that process simply read the file and pass the XML document? When I said
Agent job, it was because I thought you had an agent job already. That was
the only reason I could envision you would use a stored procedure for
the wrong job.




--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages