"Web Services Task" Configuration

Question

"Web Services Task" Configuration

nazaninahmady_sh

Default port

Points: 1465
More actions
November 25, 2008 at 7:09 am

#196631

hello,
i want to export sharepoint list data to SQL Server 2005 data base, for this purpose i use SSIS, and for using SSIS i have to use "Web Services Task" ,
please help for configuring "Web Services Task"
i can not find and configure it.
regards.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

Web Service task is under the control flow , not the data flow, so look for it in there.

It is fairly straight foward to configure just add the URL and the location of the WSDL in the properties. Pick the web service and method you need to use. You can either ouput to a variable or a data file. You can then read this file into a dataflow as you would any other file.

nazaninahmady_sh Default port Points: 1465 More actions · Answer 2

thank you for your reply'

but from where i have to configure it, where is the "Web Service Task"? is it in management studio? or .... i can not find it.

steveb. SSC-Forever Points: 46733 More actions · Answer 3

it is in SSIS which is a part of BIDS / VS.NET that is installed with SQL 2005.

have you used SSIS before?

nazaninahmady_sh Default port Points: 1465 More actions · Answer 4

hello,

Thanks alot,

i Found it.

please help me for configuring Web Service Task for Exporting Sharepoint list data to SQL Server 2005, please introduce me a Step by Step manual.

and another question is ,is it( configuring Web Service Task for Exporting Sharepoint list data to SQL Server 2005), possible with out programming?

regards

steveb. SSC-Forever Points: 46733 More actions · Answer 5

I dont really know anything about SharePoint, does it have a WebService that you can call? or can you access the database behined it?

Setting up a web-service task does not take any programming it is all point and click, doing something useful with the data may require programming though..