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.