shawn_ramsey wrote:Why not create a view on the SQL Server database that does the query to the linked table. Once you have imported the metadata you can drop the view and use the fully qualified (4 part name) in the ODBC generated SQL. Better yet leave the view and use it for the ETL.
If I was allowed to create it myself I would, but I would first have to go through the Dba's. If I have 10 - 20 tables in one linked mdf, I would first have to put in a request to create select * stored procedures for all my tables. It has been a hassle just getting the support setting up the linked server. Is there any other way?