Posted by Jimbo on 05/31/07 18:31

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: PACKAGESTART / PACKAGEEND In SSIS
• Prev in forum: Re: needed: 1 + null = 1 (Correction)
• Thread view: DTS w/ Oracle Issue

[Reply to this message]