Hi,

I have a client that needs to issue soap calls to a third-party web
service from within a DTS package. Is this even possible? I've
looked everywhere and found the sqlxml, but that looks like it
provides a soap web service, not consumes one.

Right now, we are consuming the same web service in an ASP.NET
application and would love to use the same code, but am really just
looking for the best solution. Basically, the only firm requirements
are that the client needs to provide a text file of items that need to
be posted to the third-party via their web service. Right now, we use
dts for the client to upload other text files, that's why I was hoping
to use the same procedure, but if we need to go another route, I'm
sure I can convince them.

Any suggestions?

Trey

Trey Bean wrote:
> Hi,
>
> I have a client that needs to issue soap calls to a third-party web
> service from within a DTS package. Is this even possible? I've
> looked everywhere and found the sqlxml, but that looks like it
> provides a soap web service, not consumes one.
>
> Right now, we are consuming the same web service in an ASP.NET
> application and would love to use the same code, but am really just
> looking for the best solution. Basically, the only firm requirements
> are that the client needs to provide a text file of items that need to
> be posted to the third-party via their web service. Right now, we use
> dts for the client to upload other text files, that's why I was hoping
> to use the same procedure, but if we need to go another route, I'm
> sure I can convince them.
>
> Any suggestions?
>
> Trey
>

Trey,

Did you find a solution?

Jonathan