When editing an existing ODBC job that has saved transformations, SQLyog 4.1 crashes when I click 'Edit SQL' in the transforation section of the ODBC wizard.
Does not happen when there are no transformations.
I can post job file if needed.
Also, I get error 1136 when running an ODBC job against an existing table if the existing table has field that does not exist in the source table. The destination table I want to update and append data to has fields that dont exist in the source. How do I avoid this error without having to modify either the source or destination tables.
Thanks
d