is there a how-to on ssis web services with salesforce.

Question

I would like to know more step by step examples on using WebServices with SSIS.

I've gotten the WSDL but, doesn't help me getting data and don't know what else to look.

---

-- IBM has jobs for USA employee to work oversea (India) and get their wages.

Answer 1

This Script Task/Component example was useful for me: http://blogs.msdn.com/b/dbrowne/archive/2010/07/08/how-to-configure-an-ssis-package-to-access-a-web-service-using-wcf.aspx

Or do you want to use standard webservice task: http://www.bidn.com/blogs/BillBrannen/bidn-blog/619/ssis-web-service-task-step-by-step

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

If you can use third-party solutions, check the commercial CozyRoc SSIS+ library. It contains Salesforce adapters among many other useful extensions.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Answer 3

I have successfully done it at my current's client.  but unfortunately, I don't have that package with me right now and wont until monday.  I'll Send you my package then if you can wait?