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!
Devart MySql Destination Column Mappings
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Devart MySql Destination Column Mappings
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.
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.
-
- Posts: 11
- Joined: Thu 01 Jun 2017 12:54
Re: Devart MySql Destination Column Mappings
I've tried that and it still doesn't refresh the fields.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Devart MySql Destination Column Mappings
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.