How to use SSIS using DBAmp?

Question

How can I use SSIS with DBamp to pull salesforce data? What I wanted is to filter salesforce data get it using SSIS and DBAmp.

Answer 1

You can use BDamp to directly pull your Salesforce data to your local SQL server database, later, you can use SSIS on that particular database.

You can follow Chapter 5 DBAmp Document as it explains exactly how to set up your connection using a DBAmp OLE DB Provider and then you can go ahead and use an OLE Data Source at the start of your SSIS data flow.