"Mogens Nielsen - WM-Data A/S" wrote:

> Hi,
> I'm currently setting up a SSIS package.
> The purpose is to read a comma-separated text file and call a webservice
> with the values from the text file using the webservice task in SSIS.
> The webservice methods are session-enabled that is, I call an
> Initialize-method, then the Add-method for each row in the text-file.
> Eventually I call a commit-method.
>
> I am able to do this in a test project, if I set a CookieContainer on the
> proxy-object of the web service. When using the Web Service Task in SSIS the
> Session object is being reset between each call.
> I suspect that SSIS is not setting a CookieContainer on the proxy object
> when using the Web Service Task.
>
> Is this method of using the web service task all wrong? Do anyone have a
> better solution to this scenario?
> I could of course write my own custom WS task component, but would rather
> use standard components..
>
> Mogens Nielsen
>
> -------------------------------------------
> Check out my BI blog here <a