Web Service Listener

Hot Topic

Maximum length sql statement that can be run in SQL CE
sql DB on Server1 and SSIS server on Server 2 problem
Matrix not displaying null fields
SQLEXPR_ADV.EXE does not detect WinXP SP1
To add one report or many
Adding Misc files to Solution Explorer
Authentication mode, connecting from webpage
Connectivity from Non Sql Servers
SqlServer2005 can support merge replication with SqlCe2.0??
Package crashes without error information

SQL Server

Failed SQL 2005 SP1 installations (Hotifx.exe crashes)
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '
default value for a parameter to select all
Trying to deploy reports accessing Oracle server
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
URGENT: Insert and Update in a transaction is getting blocked
Cannot connect to SQL Server 2005 April CTP from remote computer
which one is better to use? (@@rowcount or using Exists)
Problem When From Sequence file insert into Oracle Destination table in SSIS Package
Transfer SQL Server Objects Task throws an error because the DropObjectsFirst property does not check whether object exists.

Web Service Listener

What would be the best way to implement a sequence where you would wait for incoming data through a web service and then execute the rest of a package I have been thinking something along the line of setting up a native web service in SQL Server 2005 that stores XML in a table where a trigger starts an SSIS package, since this can't be done in SSIS alone, can it

Regards,
Lars Ronnback


Answer this question

Web Service Listener

  • Tammy P

    I asked about something similar to this once. I wanted to push data into a data-flow in the opposite way to how you can read data from a data-flow using the DataReader destination.
    Kirk Haselden replied to me and basically it can't be done. Inherently there still has to be an execution of a package at some point in time.

    SSIS "pulls" data - you can't "push" data to it.

    You can do event based SSIS execution i.e. When something happens, execute a package. You could do that and have it suck data out of your WS.

    -Jamie


  • VBNewStudent

    Are you asking how to consume a web service from within SSIS If so, I'm currently on a project where I have to do exactly this so I know a little bit about it. Basically your best bet is to build a web service proxy and then reference that proxy (which is a DLL) in a script task/component.

    If you but Donald Farmer's book you'll have access to a downloadable chapter that tells you exactly how to do this.

    -Jamie


  • AnuR

    Thanks, I hadn't flipped to the last page and registered. However, I suspect the chapter you are referring to is the one entitled "Web Services with SSIS Scripts (Coming Soon...)", which is not yet available. Just to make sure we understand eachother, I would like SSIS to respond to incoming data, where the delivering systems push data to SSIS using a web service, rather than having SSIS pull the data from the systems. If this is what is called consumption of a web service then that is what I want.

    The reason for this is that I want to "trickle-feed" an active data warehouse and a push strategy from the systems is more desireable than a pull one, since the timing of delivery is then delegated to the systems in which changes occur.

    Thanks!
    Lars Ronnback

  • Web Service Listener
Answer this question