Hi, I have a webservice which connects to a remote AS400 server and dumps a large amount of data into a SQL Server database. I have been trying to call the service using an SSIS package. I tired using the Web Service task but the task times out as the webservice takes longer than 300 seconds, So i tried using the Script component in a DataFlow task but the package still timed out. Is there a better way of running the webservice from an SSIS package ? I am not expecting any result from the webservice so i don't mind if the package just initiates the call and moves to the next step. I would appreciate any help on this. Thank you.

Referring BOL for Web Service Task, it essentially waits for a response from the web service. What you need above is a asynchronous call to the webservice i.e. a fire a forget. Use a script task to invoke the async call back method of the web service. What a async call back does is, it invokes the web service and the return comes back immediately to the caller without waiting for a response. Check this for more information on async callbacks.http://btsbee.wordpress.com/

Referring BOL for Web Service Task, it essentially waits for a response from the web service. What you need above is a asynchronous call to the webservice i.e. a fire a forget. Use a script task to invoke the async call back method of the web service. What a async call back does is, it invokes the web service and the return comes back immediately to the caller without waiting for a response. Check this for more information on async callbacks.http://btsbee.wordpress.com/

the async call works like a charm. Thank you very much btsbee !