Posted by Dan Guzman on 06/01/07 10:37

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" <jamesferris@hotmail.com> wrote in message
news:1180626867.763717.260180@j4g2000prf.googlegroups.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
>

• Next in forum: Re: needed: 1 + null = 1 (Correction)
• Prev in forum: Re: dbinit(), dblogin(), how often?
• Thread view: Re: DTS w/ Oracle Issue

[Reply to this message]