DTS and SOAP Web Service

Trey Bean

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

Jan 30 '07 #1

Subscribe Post Reply

3092

Jonathan Roberts

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

Feb 3 '07 #2

by: Doug Farrell | last post by:

Hi everyone, I'm trying to build a program to interface to a SOAP/XML interface provided by one of our vendors. This interface is built with MS SOAP Toolkit 3.0, so I'm guessig they are running...

Python

sending soap over http

by: Mark | last post by:

i have a very simple web servive Imports System.Web.Services <System.Web.Services.WebService(Namespace:="urn:Example1")> _ Public Class Example1 Inherits System.Web.Services.WebService

.NET Framework

SOAP Proxy for VC++

by: Leonid | last post by:

Thanks a lot for your time! Here is WSDL: <?xml version="1.0" encoding="utf-8"?>

.NET Framework

Calling SOAP Method from VB.NET

by: Cleo | last post by:

Hi, I am trying to call a WebService Method written in Weblogic from VB.NET and I am getting the following error. I am using SOAP Caal s from VB.NET. Please find the wsdl file and my code. ...

Visual Basic .NET

Sending XML SOAP message directly to web service from 3rd party app.

by: Paul Hale | last post by:

I have a vb.net web service and client that are both working fine. If someone wanted to consume our web service using .NET, no problem. Im a little confused on how non .NET clients would use the...

.NET Framework

deserialization arrays in Axis SOAP messages

by: parrot toes | last post by:

Summary: I have been trying to make requests of a web service provided by Axis using a dotnet client with code generated by wsdl.exe and have been getting exceptions when trying to process the...

.NET Framework

.Net client having problems w/SOAP Header to Axis WS

by: Daniel Thune, MCSE | last post by:

I am having a problem with formatting a SOAP Header in a .Net client. The client calls a Java Axis 1.1 based web service. In order to authenticate the caller, the web service call is intercepted by...

.NET Framework

SOAP Body

by: Bryan Dickerson | last post by:

Ok, simple question: from a VB.Net web service (as I've said before, I'm a newbie to SOAP), how would I get the SOAP body into a string? My boss and I concur that it, at least from our...

.NET Framework

gSoap authentication from C# Soap Client

by: Enda Manni | last post by:

Hi, I have a gSoap Web Service written using C++, it uses SOAP username and password authentication. I also have a C# form client consuming the web service, all this was working fine until I...

C# / C Sharp

C# SOAP Authentication to non C# web service

by: Enda Manni | last post by:

Hi, I have a gSoap Web Service written using C++, it uses SOAP username and password authentication. I also have a C# form client consuming the web service, all this was working fine until...

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Similar topics