Using web services as data source for SSIS


  • I need to test using web services as the data source in a SSIS package. As I do not have any web services ready already, I have divided my task into two:

    1. Create a web service that exposes data
    2. Use that web service as the data source and use Web services task, HTTP connection manager to read the data.

    Now I know that No 1 is not possible using SQL server as there is a known bug. Any of you have tried out using any other web services as data source for SSIS?
    Thursday, September 29, 2005 12:39 PM

All replies