|
Posted by DA Morgan on 05/31/07 19:36
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
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Navigation:
[Reply to this message]
|