Explore Courses Blog Tutorials Interview Questions
0 votes
in Salesforce by (11.9k points)

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.

1 Answer

0 votes
by (32.1k points)

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.

Browse Categories