is there a how-to on ssis web services with salesforce.
-
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.
All Replies
-
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
Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
- Proposed As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, May 07, 2012 8:32 AM
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, May 10, 2012 2:48 AM
-
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.
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

-
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?

