Devart Forums

I have no problems using this component for Insert operations, but how do I use it for Update?

I have a SQL Server view containing a list of Contacts that are currently subscribed to various Lists that I want to Unsubscribe.

I tried using a Data Flow component with by view as the OLE DB Source and connected to the Devart MailChimp Destination component with the Action set to Update. When I click on Column Mappings on the Advanced Editor I get "Error at {Destination}: The name of the crm object is not specified". {Destination} is my component name.

What does the error mean? I couldn't find any documentation on SSIS Components.

KevinSeerup wrote: ↑Thu 07 May 2020 07:02When I click on Column Mappings on the Advanced Editor I get "Error at {Destination}: The name of the crm object is not specified". {Destination} is my component name.

Please open Advanced Editor for Devart MailChimp Destination, navigate to the Component Properties tab, and set the ObjectName property. This should fix the error.

KevinSeerup wrote: ↑Thu 07 May 2020 07:02I couldn't find any documentation on SSIS Components.

Refer to https://www.devart.com/ssis/download.html > "HTML Help documentation" (download, right click > Properties > Unblock), navigate to Custom Properties Reference > Devart MailChimp Destination.

Thank you for your help.

The documentation on the Update Action is a bit sparse.

I want to update the ListMembers Status column to "Unsubscribed". So I have a column called NewStatus in my Input as well as the Id of the ListMembers table. In my mapping I have joined the Input and Output ID columns, and joined my input NewStatus with the Output Status.

Does that sound correct or am I missing something? I don't want to accidentally unsubscribe the wrong Members as there is no easy way to reverse this in MailChimp.

Column 'STATUS' is updatable via API v3. Please add "api version=v3;" to your connection string.

My connection string already has "API Version=v3".

Are you able to answer my question: "Does that sound correct or am I missing something?"

That sounds correct.