ETL and Data Integration tools - Modern ETL software for everyone

Hello

Thank you for the help so far

However, when I go to run one of the jobs (“Clinic-Import”), I’m getting a couple of errors. Attached is also the log file for your review. Any questions, let me know. Thank you.

1. “Transformation rolled back” message. See screen shot below:

2. After running job, I look at “Transformation Log”, I have lots of ODBC Errors regarding MySQL, which is my destination DB. My source DB is FoxPRO, my Destination is MySQL. Below is a screenshot of transformation log:

Holman

Holman

Try setting in sql before

SET sql_mode='ANSI_QUOTES'

Why do not you try using direct mysql connection instead of ODBC
It should be much faster

Best Regards
Mike,
DB Software Laboratory

That seem to work. Let me test the rest of them and see how it goes.

As to using Direct MySQL connection. How do I go about doing that in VI? I would love to do it that way.

Can't you see MySql Icon in the Object tree?

Mike

Yes, see screen shot below:

Just right click on it and create new connection.