Showing posts with label soap. Show all posts
Showing posts with label soap. Show all posts

Monday, March 19, 2012

DTS and SOAP Web Service

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?

TreyTrey Bean wrote:

Quote:

Originally Posted by

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

Sunday, March 11, 2012

DTS activex task to query soap web service ?

Hello there
I wanted to know if anybody has an example of an activex task in a dts that
will query a soap service ?
I never queries a soap service from vbscript so I guess i need to see an
example to start ? please
ThanksSimo Sentissi wrote:
> Hello there
> I wanted to know if anybody has an example of an activex task in a dts tha
t
> will query a soap service ?
> I never queries a soap service from vbscript so I guess i need to see an
> example to start ? please
> Thanks
>
There have been various toolkits released and the .Net tools have good
support for SOAP. Trying to write that by hand in VBS would seem like
very hard work. I would look to develop something in .Net that does the
work and wrap it either as a custom task or as a COM DLL for use from
the ActiveX Script.
Darren
http://www.sqldts.com
http://www.sqlis.com

DTS activex task to query soap web service ?

Hello there
I wanted to know if anybody has an example of an activex task in a dts that
will query a soap service ?
I never queries a soap service from vbscript so I guess i need to see an
example to start ? please
Thanks
Simo Sentissi wrote:
> Hello there
> I wanted to know if anybody has an example of an activex task in a dts that
> will query a soap service ?
> I never queries a soap service from vbscript so I guess i need to see an
> example to start ? please
> Thanks
>
There have been various toolkits released and the .Net tools have good
support for SOAP. Trying to write that by hand in VBS would seem like
very hard work. I would look to develop something in .Net that does the
work and wrap it either as a custom task or as a COM DLL for use from
the ActiveX Script.
Darren
http://www.sqldts.com
http://www.sqlis.com

DTS activex task to query soap web service ?

Hello there
I wanted to know if anybody has an example of an activex task in a dts that
will query a soap service ?
I never queries a soap service from vbscript so I guess i need to see an
example to start ? please
ThanksSimo Sentissi wrote:
> Hello there
> I wanted to know if anybody has an example of an activex task in a dts tha
t
> will query a soap service ?
> I never queries a soap service from vbscript so I guess i need to see an
> example to start ? please
> Thanks
>
There have been various toolkits released and the .Net tools have good
support for SOAP. Trying to write that by hand in VBS would seem like
very hard work. I would look to develop something in .Net that does the
work and wrap it either as a custom task or as a COM DLL for use from
the ActiveX Script.
Darren
http://www.sqldts.com
http://www.sqlis.com

DTS activex task to query soap web service ?

Hello there
I wanted to know if anybody has an example of an activex task in a dts that
will query a soap service ?
I never queries a soap service from vbscript so I guess i need to see an
example to start ? please
ThanksSimo Sentissi wrote:
> Hello there
> I wanted to know if anybody has an example of an activex task in a dts that
> will query a soap service ?
> I never queries a soap service from vbscript so I guess i need to see an
> example to start ? please
> Thanks
>
There have been various toolkits released and the .Net tools have good
support for SOAP. Trying to write that by hand in VBS would seem like
very hard work. I would look to develop something in .Net that does the
work and wrap it either as a custom task or as a COM DLL for use from
the ActiveX Script.
--
Darren
http://www.sqldts.com
http://www.sqlis.com