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
Calling a Web Service with data from a SQL Server table one row at a time
Hot Topic
- How to call remote object using C# Stored procedure
- StrToMember issue
- Remote execution of package via dtexec and "Access Denied"
- Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
- non clustered index on heap
- Disable a container at runtime via ScriptTask
- Scrpting to genrate surrogate keys
- DTC - Transaction context in use by another session
- Default member problem
- cant connect to server from another machine
SQL Server
- dynamic query
- The Publisher failed to allocate a new set of identity ranges for the subscription
- SQL Syntax
- SQL Management Studio Express
- Problems creating a stored procedure in Management Studio
- Connection string for SqlCeConnection
- Beginner T-SQL Question
- Why AS2005 has only Windows Authn unlike SS2005?
- How to Delete Files on Maintenance Plan
- What are the performance characteristics of RDA?
Calling a Web Service with data from a SQL Server table one row at a time
VuDZ
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
anjanesh
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
oer
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