dbTalk Databases Forums  

SSIS 2008 web service task

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


Discuss SSIS 2008 web service task in the microsoft.public.sqlserver.dts forum.



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

Default SSIS 2008 web service task - 03-29-2010 , 11:29 AM






I'm (attempting to) converting a legacy Perl program to SSIS. The apps
purpose is to sign in to a web service, submit a request and receive an xml
file with results. The company that publishes the web service spec says it
uses "WSLx Authentication" and that I need "must authenticate via WSLx by
including a encrypted persistant cookie string in their HTTPS request. This
encrypted string contains the WSLx username for the client application, the
source IP address of the request, and an expiration date. This information
is decrypted and validated by a WSLx server agent ". I have that "cookie
string" from the Perl code.

I can create an http connection and "Test Connection" succeeds. In the Web
Service Task editor, I select that HTTP Connection Manager and the WSDL file
that I found at the site of that connection.

When I click on input there are no services listed. I thought this was
drawn from the WSDL file. When I view the WSDL file it has a <Service ...>
tag.

I haven't done this (web service task) before but it *seems* like everything
is in place. What is missing? What do I need to look for? What do I need to
ask this forum for? what other information do you need to understand my
question?

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.