Thank you. I got it to work now.... However, I'm now having problems with adding new records to the DB. I have Transformation set to "Add New and Update Old". The problem is that is only doing an update. There are at least 10 new records and for what ever reason, they are not being picked up.
By the way, I'm going from a FoxPro DB to a MySQL DB.