Well, I know calling a web service is possible. But, it involves using the soap toolkit to write a com component. To invoke the com component you have to use the sp_oA* family of system stored procedures which require sysadmin level privileges. Basically, a web service is supposed to be called from the client, not the database. There are a host of concerns for dba's involved with this. Obviously, they can't give sysadmin level permissions to anyone. Performance is bad. Deadlocking will occur. The soap tool kit is or will depreciated.
I'd still like to know how to invoke a function in a .dll from a dts active x step if anyone knows how.
k