Sign Up ›
  • Technical Support
  • NEWBIE
  • 0 Points
  • Member since 2011
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 3
    Replies
2 replies

Consuming API in SSIS

Hi,

 

I am trying to consuming the apex APIs in the SSIS packages (2008). I included a script task in my code. In the script task I added the Web Reference using the WSDL from salesforce.com. But in my .cs file its not able to recognize

 

sforce.SforceService class. In the Object Browser too I do not see this class under sforce.

 

Could someone please help in how to get the reference included in the code.

 

thx

sr

3 replies

Where can I get dll?

We are trying to do some data integration between salesforce and our database. We use SQL SSIS packages to connect to Salesforce.com.  

To order to access salesforce.com webservice from SQL SSIS package, we need to have .asmx link(URL) for enterprise.wsdl  and dll file of salesforce webservice.

We need to reference saleforce dll to access web methods from VB scripts. We cannot use wdsl file in SSIS. We need to have .asmx url.

Where can I get dll file and .asmx link for enterprise.wsdl file.
 
Help me please.
 
 
Thank you.
 
 
3 replies

SSIS Component for SFDC

Does anyone know any components besides the Adaptorworx component for SSIS Packages.