COZYROC to connect Salesforce from SSIS provides SSIS Library to interact with multiple 3rd party services including Salesforce. I have implemented POC to pull data from Salesforce using COZYROC Connector!

Here are the step by step information to pull data from Salesforce Object…

• Installation: You may use Trail version or purchase the software depending on the requirement. For this Demo I have used Licensed version…
• Create Connection Manager for Salesforce/ Your Org
o Initiate New Connection and select SFORCE and Add

• Enter Login and Password (NOTE: Password must include the Security Token)
o If you are configuring it for Test environment, change the Server URL at Advanced options
 You can try any of these URLs for test environment
• Click on Test Connection to confirm that the credentials are correct and working
• Create a Data Flow Task in Control Flow and select Salesforce Source
• DoubleClick Salesforce Source and select the Salesforce Connection which is just created on Connection Managers Tab
• Select Component Property tab and select Input Type as Object, Select the Object and add Object Filter
• NOTE: Object Filter is SOQL Query; 2015-08-12T07:01:41-00:00> Filters the rows which are updated after given date
o Make a note of the Syntax and Date format…
• For validating I am just passing the results to Derived Column component and enabled data viewer.
• Executed the job… Job completed successfully and I can see the data.


This entry was posted in Salesforce, SQL Server, SSIS and tagged , , , . Bookmark the permalink.

1 Response to COZYROC to connect Salesforce from SSIS

  1. tanveermahtaj yakoobsheriff says:

    Hi, Thanks for your article. I have doubt related to cozyroc salesforce source. One of our package uses cozyroc salesforce connnection. I am able to run and deploy into ssis catalog. But when i import the same package from SSIS catalog to my solution, package looses the salesforce connection. I mean the package gets imported but salesforce connection is missing. Can you please let me know what settings and why connection is lost after import

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s