Posted by Erland Sommarskog on 06/29/07 21:27

KEN (kenkopicky@gmail.com) 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@sommarskog.se

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

[Back to original message]