semlun
asked on
Call webservice and insert/update sql table
Hi,
I have a basic transaction there I want to read the output from a webservice and put the result in a sql table and update this table after scheduled timebase?
//Mattias
I have a basic transaction there I want to read the output from a webservice and put the result in a sql table and update this table after scheduled timebase?
//Mattias
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
semlun: does it mean you will go with CLR?
as one of ideas, you may use WebService task in SSIS
more:
about Web Service Task
http://msdn.microsoft.com/en-us/library/ms140114(v=sql.105).aspx
and the nice example:
Calling a Web Service from a SQL Integration Services package
http://www.codeproject.com/Articles/24999/Calling-a-Web-Service-from-a-SQL-Integration-Servi