Calling A WEB SERVICE FROM SQL SERVER

• TaffyLewis

  Ten Centuries

  Points: 1033

  More actions

  July 6, 2004 at 1:10 pm

  #162910

  Can you call a .net web service from a sql server stored procedure or dts package?

   

  Taffy

  

• lakusha

  SSCommitted

  Points: 1857

  More actions

  July 6, 2004 at 1:45 pm

  #513518

  Yes. Easily but not nicely.

  a) build a COM. You can call a COM from both DTS and T-SQL (sp_OA* procedures)

  b) build an executable and call it with parameters. Again DTS or T-SQL.

  c) Build an extended stored proc.

  etc (it goes worst with each scenario)

  Wait for SQL 2005 if you can (another year is realistic). Or I would recommend going with a COM.