dbTalk Databases Forums  

2005 SSIS Question

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


Discuss 2005 SSIS Question in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joe
 
Posts: n/a

Default 2005 SSIS Question - 04-04-2005 , 05:43 PM






I am trying to set up a webservice in SQLXML 4.0 in Yukon Beta 2. I am then
trying to consume that service via a Web Service Task in SSIS (SQL Server
2005 DTS) but getting an error stating "WSDL not supported". Anyone have any
experience with Web Services Task via 2005?

thanks
Joe

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

Default Re: 2005 SSIS Question - 04-05-2005 , 08:30 AM






There was a bug in Beta 2 around this task, as myself and others got exactly
the same error.
Try the latest CTP perhaps?

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Joe" <Joe (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am trying to set up a webservice in SQLXML 4.0 in Yukon Beta 2. I am
then
trying to consume that service via a Web Service Task in SSIS (SQL Server
2005 DTS) but getting an error stating "WSDL not supported". Anyone have
any
experience with Web Services Task via 2005?

thanks
Joe



Reply With Quote
  #3  
Old   
Jamie Thomson
 
Posts: n/a

Default Re: 2005 SSIS Question - 04-05-2005 , 01:32 PM



Only a very limited amount Joe. And even then only against Web Services
implemented in .Net. I have had it working though! What I haven't done is
use it against a WS that I have built, only against a publicly available WS.

From that limited experience, if you point the http connection manager at
"<WS URL>?WSDL" you'll be able to get at the WSDL, download it to your box,
and you should be away. Have you already managed to get the WSDL from the
WS?

My tip would be to get it working against someone else's WS first before you
start to use it against one of your own!

Hope that helps!

Regards
Jamie Thomson
An SSIS blog - http://blogs.conchango.com/jamiethom...tegory/71.aspx


"Joe" <Joe (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am trying to set up a webservice in SQLXML 4.0 in Yukon Beta 2. I am
then
trying to consume that service via a Web Service Task in SSIS (SQL Server
2005 DTS) but getting an error stating "WSDL not supported". Anyone have
any
experience with Web Services Task via 2005?

thanks
Joe



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.