Is anyone executing SSIS packages using a web service similar to the example in http://msdn2.microsoft.com/en-us/ms403355(SQL.90).aspx
From what I've read, there is a new HTTP server embeded in SQL Server (so we don't have to have IIS) that this could be done from
Remote Execution of SSIS Packages via Web Service
Scott A.
I don't see the link between the BOL topic and web services, or how this impacts the lack of IIS. I'll make some random statements instead. The code illustrated could be incorportaed into a normal .Net written web service. Web services that you write yourself in code like this require IIS.
The ability to expose SQL objects such as stored procedures as web services does not require IIS on the SQL Server, it uses another technology, the name escapes me right now, but you can create the HTTP endpoint within SQL Server itself. These "native" SQL Server web services are just exposing objects, there is no ability to add code or such like, unless you create a stored procedure in managed code, CLR integration within SQL, but this is still below the WS layer, and would of course work from a query tool as well as the HTTP endpoint.
I can see no way to replicate the functionality of the code included in the BOL topic within SQL using the new WS support and thereby eliminating the need for IIS.
Mark Fasano
I'm close to solving this and will post the code when I do. Thanks for your attempt.