SSIS Devart Magento Destination

SSIS Devart Magento Destination

Postby tetiferr » Fri 18 Nov 2016 16:45

I made this little package to update data from a csv file. There are only 4 fields that I read from csv file and the same fields should be written on the table InventoryStockItems.
Among these fields is Id_Products which is the primary key of the table InventoryStockItems.
I configured Magento Destination correctly :roll: and his map field (very easy) bat when I run package have the error:

[size=85]"Error : System.InvalidOperationException: Delete and update operation requires ID column.

What does it mean ?How can I correct this error)

thank you.
Posts: 1
Joined: Fri 18 Nov 2016 16:30

Re: SSIS Devart Magento Destination

Postby Pinturiccio » Mon 21 Nov 2016 16:16

Devart SSIS Data Flow Components work with Magento via Magento API. InventoryStockItems is a read-only entity and cannot be used in the Magento Destination component.

We have fixed the error text. Now it will reflect the reason of the issue instead of the non-informative message "Delete and update operation requires ID column".
Devart Team
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Return to SSIS Data Flow Components