Why not run a DTS/SSIS job from a stored proc that hits a webpage/webservice?
Cameron Johnson wrote: > Hi, all. > > I'm trying to hit a remote web service from within a SQL stored procedure. I > don't need any data back; it's just a call to initiate another process. > > If I were doing this in CF, it would be: > > <cfinvoke webservice="http://www.domain.com/webservices/webservice.asmx"; > method="AddUser" ID="#ID# /> > > > Is there a way to do this from within a stored procedure? I've seen some > examples using sp_OACreate and sp_OAMethod, but it seems overkill for what > I'm trying to accomplish. And, I'm having a hard time deconstructing the MSDN > documentation. > > Thanks for the help/tips/info/other. > > Cameron > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3230 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
