By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,612 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

DTS 2005 and quoted table names

P: n/a

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.
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
John Hardin (jh*****@crsretail.com) writes:
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?


That question is best asked in microsoft.private.sqlserver2005.dts.

See http://go.microsoft.com/fwlink/?linkid=31765 for access information.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.