August 15, 2008 at 2:49 pm
We collect data from an external provider which we use a 3rd party system (built on Java) to submit SOAP XML requests to and then we use SSIS to load the files which are sent to us via the 3rd party software and the external provider.
What I want is to send the SOAP XML request directly from SQLServer and then directly process the returned stream.
Is this possible and if so can someone point me in the right direction.
David
August 16, 2008 at 1:04 am
You can use SOAP from within SSIS. You can then use SSIS to load the files (You already doing that though)
If you _really_ wanted to do it from SQL as you state, look at service broker (not entirely sure though) or CLR.
I would stick with SSIS though.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 16, 2008 at 5:05 am
Good to know it can be done. However, I cannot find anything in SSIS about SOAP or setting up our connection to the data provider. We really want to keep everything in SQLServer and not use these additional apps.
If you have any pointers on where to look, let me know.
Thanks so much!
August 16, 2008 at 7:13 am
Tried the web services task?
If it does not suit all your needs (as it did not mine) you can create your own custom task. Fairly simple yet limitless in what you want it to do as it is just normal c#.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 16, 2008 at 8:14 am
I have not but will look. Thanks!
As for the custom task, I am new (1 week in) to SQL Server and SSIS after years in the Peoplesoft / Oracle world. Would you be OK if I asked you further questions on the custom stuff later?
David
August 16, 2008 at 12:10 pm
one week in and about to build custom tasks... Ouch 🙂
So long as you have a basic grasp on vb.net or c#, you should be fine.
As for asking questions, this is why the forum is here...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
October 8, 2008 at 10:24 am
Was there ever success on this project? I am using SSIS with a Web Service task but can't get past a "505 HTTP request version not supported"
Running 64 bit/SQL 2005
Connecting into the new Cisco Call Manager (v7) which is Apache/Tomcat.
Any thoughts?
Thanks
michael
October 9, 2008 at 9:36 pm
Success? Not really but I am constrained by the fact the web service is a bit old fashioned and does not make use of a WSDL. I guess I will have to write a script to handle that but am plenty busy on other, more pressing, issues.
If anyone has any insight to connect to a web service not utilizing a WSDL and requiring a digital cert to connect, I would love to chat with you.
David
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply