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.
Documentation on using Devart MailChimp Destination component
-
- Posts: 9
- Joined: Thu 27 Feb 2020 00:17
Re: Documentation on using Devart MailChimp Destination component
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: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.
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.
-
- Posts: 9
- Joined: Thu 27 Feb 2020 00:17
Re: Documentation on using Devart MailChimp Destination component
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.
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.
Re: Documentation on using Devart MailChimp Destination component
Column 'STATUS' is updatable via API v3. Please add "api version=v3;" to your connection string.
-
- Posts: 9
- Joined: Thu 27 Feb 2020 00:17
Re: Documentation on using Devart MailChimp Destination component
My connection string already has "API Version=v3".
Are you able to answer my question: "Does that sound correct or am I missing something?"
Are you able to answer my question: "Does that sound correct or am I missing something?"
Re: Documentation on using Devart MailChimp Destination component
That sounds correct.