"Backslider" wrote:

> I created a custom DTS object that does its work by calling a
> webservice. When you create the object in DTS, it lets you set the
> user/pw you want to use to authenticate to the webservice. The problem
> I am having is that once I authenticate to the webservice within DTS,
> it always uses the same authentication when contacting the service.
>
> So, for example, I drop a new instance of my object into a package. It
> connects to the webservice as me. I set up the parameters of the task,
> including telling it to connect as User="test". If I run it, my code
> creates a new web service proxy object, sets the credentials correctly
> on the object, but the webservice still gets called as me.
>
> If I exit out of SQL Server and go back in, and run it, it correctly
> connects as User="test". But then if I try to edit the task, and give
> a new user and password, it still always tries to connect as "test".
>
> It seems whoever I initially connect to the webservice as, that is the
> information that DTS will use for the entire session.
>
> Is there any way to do what I want to do?
>
> thanks
>