DTS w/ Oracle Issue

[Jimbo]

Im having an issue with DTS and I dont know if anyone else has
experienced this...In my transformation I have a sql statement that
executes against oracle..in it I'm selecting COUNT(DISTINCT
I.PX_INVOICE_ID) ...however when the DTS package executes I get an
error stating that "DISTINCTI"."PX_INVOICE_ID" is an invalid
identifier..why is it concatenting this?

Thanks

Jim

[DA Morgan]

Jimbo wrote:

Im having an issue with DTS and I dont know if anyone else has
experienced this...In my transformation I have a sql statement that
executes against oracle..in it I'm selecting COUNT(DISTINCT
I.PX_INVOICE_ID) ...however when the DTS package executes I get an
error stating that "DISTINCTI"."PX_INVOICE_ID" is an invalid
identifier..why is it concatenting this?

Thanks

Jim

It isn't Oracle ... so what version, what connection driver, etc?

But do you really have a schema named "I"? Seems strange.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Dan Guzman]

I agree with Daniel that this is most likely a client driver issue. I
haven't run into the problem myself but I've only run only simple SQL
statements using the Oracle drives. Can you post the full SQL statement?

You might quoting the identifiers as a possible workaround. For example:

SELECT COUNT("I"."PX_INVOICE_ID")
FROM "MYSCHEMA"."INVOICES" I;

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Jimbo" <ja*********@hotmail.comwrote in message
news:11**********************@j4g2000prf.googlegro ups.com...

Im having an issue with DTS and I dont know if anyone else has
experienced this...In my transformation I have a sql statement that
executes against oracle..in it I'm selecting COUNT(DISTINCT
I.PX_INVOICE_ID) ...however when the DTS package executes I get an
error stating that "DISTINCTI"."PX_INVOICE_ID" is an invalid
identifier..why is it concatenting this?

Thanks

Jim

[Jimbo]

It appears to be with the OLE data provider...when upgrading it to 10
it worked..also the ODBC driver for Oracle worked....really weird

-Jim