An X009 was returned when the query from a Query window was executed. The database table has been altered since the .MIG file was saved, or there is some other problem with the validity of the SELECT statement in the Query window.
Generate and test your SQL using SQLWizard and paste it into the Migrate window.
