Thanks Howard,

I've been meaning to learn SSIS for some time - and I guess the time is now!

~Erik

Hi Jared,

You are the man! I was able to get the native SQL Control Center working for queries by installing a newer version. Now for some reason I can also...

Do you really think so? I'd have thought that any SQL query tool running locally on the MySQL server (that returns a result) would prove that end of it...

~Erik

Apparently queries will run on the MySQL server. While they don't seem to run in the native tool, someone has installed a different management tool on that server - perhaps...

Howard,

You may have hit on something. Perhaps one of you all can guide me in this as my MySQL knowledge is nil.

I remoted into the MySQL server in question &...

Hi Lowell,

Sad to say I did think of that. In fact I decided to set up the data warehouse as 32 bit due to issues I have had in the...

Sorry Jared - I was not explicit. I am trying to get the data from an old MySQL database into SQL Server 2008 R2. the new ODBC driver won't work...

I tried the newer ODBC driver first but it is incompatible with the database version.

Hello,

I tried recreating the linked server via script but am seeing the same behavior. I used the script from here:

http://www.sqlservercentral.com/Forums/Topic340912-146-11.aspx#bm1182941 (Thanks Theo!)

One thing I have seen mentioned...

First, I'd like to thank you guys for lending a hand.

Here is some background on what I tried - setup wise. My ODBC driver is MySQL ODBC 3.51 Driver &...

With that syntax I get no errors but am again stuck on "Executing query...".

As an off the cuff test I tried using CR to pull all of the data...

Hi Jared,

Thanks for your reply.

If I try the using that query with the wild card I get a syntax error. It seems like it should work, but I am no...