Calling a Web Service with data from a SQL Server table one row at a time

Hello

I am trying to call a Web Servie within a SSIS package. I want to pull a row at a time from a SQL Server 2005 table and pass this data values onto the web service.

Any help is highly appreciated!

Kind Regards

Gayatri

I guess it rather depends on what you want to do with the Web Service. Can you give us more details?

You can certainly call a web service row-by-row from a script component in the data flow. This may work for you, but it rather depends on what you want to do once you have called the service.

Donald

|||

Hi Donald

Many thanks for your reply. Web Service is written to accept fields of the records from the table I am reading. I've gone as far as accessing record fields in a script task whlie the records are being read. Where I am lost is assigning those field values to the web service input fields.

My Web service interface is as follows:

Service: PersonWebserviceService

Method: CreatePersonRecord

CreatePersonRecord Method accepts as input a structure to hold fields data values as follows:

(On the input tab)

Name: Key

Type: LegacysystemData

Values: each value in turn have a Name, Type and Value components (eg: Name: ClientNo Type: String and Value). Value is the field I need to access in the script task to assign the record field value I read in)

Your help is much appreciated.

Gayatri

|||

Hi Donald

During the course of the day I managed to Create a web service proxy for my web service and reference it in the script task. But when I run the SSIS Package I get the following error:

Could not load file or assembly 'PersonWebserviceService, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

Hope you could shed some light

many thanks

Gayatri