DTS Error

We are getting an error message that states error source:
Microsoft source oledb provider for sql server,
unspecified error. Invalid columname usertyp. This is
happening when we try to create a dts package between sql
server database and access database. Any idea on how to
slove this problem or what is going on.Use Profiler to see whats up.
>--Original Message--
>We are getting an error message that states error source:
>Microsoft source oledb provider for sql server,
>unspecified error. Invalid columname usertyp. This is
>happening when we try to create a dts package between sql
>server database and access database. Any idea on how to
>slove this problem or what is going on.
>.
>

DTS 2005 and quoted table names

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.John Hardin (jhardin@.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, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp