SQL Server Performance

webservice returns dataset

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 11, 2007.

  1. fmardani New Member

    Hi,
    How do I use SSIS to return data from a function in a webservice which returns a dataset?
    Thanks
  2. satya Moderator

    Look at the books online for table valued functions and also this<a target="_blank" href=http://rickgaribay.net/archive/2006/12/21/Distributed-SQL-Server-Integration-Services.aspx>http://rickgaribay.net/archive/2006/12/21/Distributed-SQL-Server-Integration-Services.aspx</a> for more information.<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />] It seems you are using SSIS upto the extent.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br />@<a target="_blank" href=http://www.askasqlguru.com/>http://www.askasqlguru.com/</a><br /><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>

Share This Page