Devart MySql Destination Column Mappings

Devart MySql Destination Column Mappings

Postby FunnyName123 » Wed 14 Jun 2017 07:09

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!
FunnyName123
 
Posts: 11
Joined: Thu 01 Jun 2017 12:54

Re: Devart MySql Destination Column Mappings

Postby Pinturiccio » Fri 16 Jun 2017 09:19

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.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Re: Devart MySql Destination Column Mappings

Postby FunnyName123 » Thu 22 Jun 2017 07:52

I've tried that and it still doesn't refresh the fields.
FunnyName123
 
Posts: 11
Joined: Thu 01 Jun 2017 12:54

Re: Devart MySql Destination Column Mappings

Postby Pinturiccio » Thu 29 Jun 2017 12:42

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.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44


Return to SSIS Data Flow Components