This is nice -- not chatty like some technical presentations, but instead, a very nice, clean, concise, substantive presentation, with discussion of important stumbling blocks that might be encountered. I found this to be extremely helpful, and I'm grateful to the producer for taking the time to present it.
You are a great teacher. Very organized. Anticipating the errors and immediately demonstrating the solutions is an excellent way to cover the gotchas and make it real.
Having never used SSIS and always considered Web Services to be some kind of magic that only developers understood, the idea of me getting data from a web service into a SQL server seemed far off. Then metamanager came along... In less than two hours I have a working solution. Thanks a lot for a great video!
I enjoyed watching this video. I love this video. Explained clearly and step by step. Please keep moving forward and produce some more videos. As and when you release videos please let me know I would like to test and reply. Thanks for education the community and your great volunteer-ship. I think you can teach very well. Can I call you my Guru? You explained happy path and I wish general problems encountered explaining may ease the audience. Thanks a bunch
I know this was a long time ago... but I used this xsl file and it stripped out all of my namespaces. stackoverflow.com/questions/5268182/how-to-remove-namespaces-from-xml-using-xslt
Hi, I am using this method and when I specify the output parameters, I get the error 'the selected web method contains unsupported arguments'. Could you please advise me what to do?
I am connecting to a web service that is https and requires authentication. If I understand correctly, the credentials stored in the http connection manager are not being used in the web service; Especially since the service itself is not asking for those parameters when selecting the method. I can get this to work in scripting vb (will try C# next), but I was hoping there could be some working this into the web service task. Basically the response I get back is "ERROR-Credentials were not supplied". Can anyone help?
Running the XML task, I keep getting this error "The process cannot access the file 'E:\ssis\webservice\cdy_weather_repsonse.xml' because it is being used by another process.". Task failed: XML Task" I am trying since 4 hours will all permutations and comibinations,
This is nice -- not chatty like some technical presentations, but instead, a very nice, clean, concise, substantive presentation, with discussion of important stumbling blocks that might be encountered. I found this to be extremely helpful, and I'm grateful to the producer for taking the time to present it.
This is one of the best videos I have seen so far on SSIS...
You are a great teacher. Very organized. Anticipating the errors and immediately demonstrating the solutions is an excellent way to cover the gotchas and make it real.
Having never used SSIS and always considered Web Services to be some kind of magic that only developers understood, the idea of me getting data from a web service into a SQL server seemed far off. Then metamanager came along... In less than two hours I have a working solution.
Thanks a lot for a great video!
I don't see any explanation of the xsl file which would help me complete this tutorial
can you please throw some light on the xsl file which you already had created
Very good explanation. Congratulations.
I enjoyed watching this video. I love this video. Explained clearly and step by step. Please keep moving forward and produce some more videos. As and when you release videos please let me know I would like to test and reply. Thanks for education the community and your great volunteer-ship. I think you can teach very well. Can I call you my Guru? You explained happy path and I wish general problems encountered explaining may ease the audience. Thanks a bunch
Ditto on the xsl operation. Please explain that file that was generated and sitting on your file system...
I know this was a long time ago... but I used this xsl file and it stripped out all of my namespaces. stackoverflow.com/questions/5268182/how-to-remove-namespaces-from-xml-using-xslt
Hi, I am using this method and when I specify the output parameters, I get the error 'the selected web method contains unsupported arguments'. Could you please advise me what to do?
The best video. Thanks.
how to do opposite? taking data from sql server table and posting to api
hello sir superb video..any video or help for the otherway data from sql to webservices..please
Great Video...Thanks
Very very good class.
Excellent !
I am connecting to a web service that is https and requires authentication. If I understand correctly, the credentials stored in the http connection manager are not being used in the web service; Especially since the service itself is not asking for those parameters when selecting the method. I can get this to work in scripting vb (will try C# next), but I was hoping there could be some working this into the web service task. Basically the response I get back is "ERROR-Credentials were not supplied". Can anyone help?
oh man thank you so much !!!!!!!!
How can it work if webservice need crediatinals for login source page?
awesome.
Running the XML task, I keep getting this error "The process cannot access the file 'E:\ssis\webservice\cdy_weather_repsonse.xml' because it is being used by another process.".
Task failed: XML Task" I am trying since 4 hours will all permutations and comibinations,
for anyone thats searching to XSLT file:
stackoverflow.com/questions/5268182/how-to-remove-namespaces-from-xml-using-xslt
Tomas Tichonovas Thank you!
XSL File is;