Devart Forums

I think I may have found an issue with the Destination component. The column mapping don't seem to refresh if I make a change to the table in the database, I have to end up deleting the destination component and creating a new one.

Do I really have to keep doing that? Or is it supposed to be refreshing?

Thanks!

When table schema is changed in MySQL, you need to perform the following actions:
1. Select Show Advanced Editor in your Devart MySql Destination component shortcut menu.
2. Switch to the Column Mappings tab and click the Refresh button.

Columns in the destination table will be refreshed and changes in the table schema will be reflected in the Devart MySql Destination component. You don’t need to delete and re-create the component.

I've tried that and it still doesn't refresh the fields.

Please tell us the version of the SSIS Data Flow Components for MySQL product and describe the steps you perform. Make sure that you modify the table structure on the same MySQL server that you connect to with the Devart MySql Destination component.