How to delete from SFDC Object in SSIS
Hi there. I have built out a suite of integrations using SSIS, SQL Server, and Devart for SFDC. It is working well.
However, I need to clear out one SFDC object before I load it again. I am the kind of guy who needs a worked example when I hit a brick wall, and I can't find one.
Can anyone help explain or show me how I do this? I've put an SFDC Destination on my canvas, I've selected a connection manager, I've specified the mode as delete, and the object name. I have zero idea what to do next :(
Cheers
Jo