We're trying to use DTS from SQL Server 2005 beta 2 to query data
from an Informix IDS server via OLEDB.
Unfortunately DTS is building queries of the form:
select * from "database":"owner"."tabname"
and the quoted table name is being rejected by the Informix server as a
syntax error.
Is there a way to keep DTS from quoting the table name in queries? Or is
this happening within the OLEDB provider?
Thanks.
--
John Hardin
Development and Technology group (Seattle)
CRS Retail Systems, Inc.