Great I'm also getting results with OPENQUERY.

HOWEVER, i'm interested in knowing why it doesn't work with the 4-part naming convention.

I get the error: Invalid object name.

Also when I try script the , I get an error '[servername].[databasename]..[tablename] contains no columns that can be selected or the current user does not have permissions on that object.'

I'm looking for a way to pull data from a MySQL instance into MSSQL. The way I want to accomplish this is by scheduling the SSIS package created with the SQL Import-Export wizard. To do so I would have to select the Tables from the LinkedServer as source.

Any and all help is welcome.