Friday, May 04, 2012 7:57 PM
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.
Friday, May 04, 2012 8:09 PMModerator
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
Saturday, May 05, 2012 12:35 AMIf you can use third-party solutions, check the commercial CozyRoc SSIS+ library. It contains Salesforce adapters among many other useful extensions.
Saturday, May 05, 2012 1:52 AM
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?