dbTalk Databases Forums  

Web services task question (wsdl)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Web services task question (wsdl) in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Panos Stavroulis.
 
Posts: n/a

Default Web services task question (wsdl) - 03-08-2006 , 06:38 PM






Hi,

I've got a scenario where I need to retrieve some xml files from a website.
The files can be xml csv, etc. At the moment we have an application written
in VB that does it, you enter the file name and then it retrieves the file
(normally an xml).

Am I right in thinking that I need a web services task to do this job? If
yes where do I get the wsdl file? The wsdl file is needed for defining what
reports are available (I think). I've asked the report providers for the wsdl
but still no answer. Also the reports are not available as an xml address so
can't use the xml interface.

What's the best way to tackle this problem. Thank you.

Panos.

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default RE: Web services task question (wsdl) - 03-09-2006 , 05:17 AM






If you just want to download files from a web site then you really need some
HTTP download component. The Web Services task is all about calling a web
service which it sounds like you do not have. The web service itself will
provide the WSDL if asked. You could have a WS that downloads files, but if
they accessible, just from a browser, use HTTP downloads it will be easier.

I don't know of a task (yet) that supports this directly but you can do it
through the script task quite easily. One method can be found here-
http://www.sqljunkies.com/WebLog/ash.../25/15653.aspx

"Panos Stavroulis." wrote:

Quote:
Hi,

I've got a scenario where I need to retrieve some xml files from a website.
The files can be xml csv, etc. At the moment we have an application written
in VB that does it, you enter the file name and then it retrieves the file
(normally an xml).

Am I right in thinking that I need a web services task to do this job? If
yes where do I get the wsdl file? The wsdl file is needed for defining what
reports are available (I think). I've asked the report providers for the wsdl
but still no answer. Also the reports are not available as an xml address so
can't use the xml interface.

What's the best way to tackle this problem. Thank you.

Panos.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.