Lou87,
This is easy after you spend 4 hours of your life trying to change the source code just go to the connection box and add the new connection . Before hitting the the finish button just go to the edit SQL option in the connection box and put as an alias the old table name. This will fix the problem.
Thanks,
Lou87 LOL