DTS w/ Oracle Issue

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jimbo
    #1

    DTS w/ Oracle Issue

    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

    Tags: None
    • DA Morgan
      #2
      Re: DTS w/ Oracle Issue

      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.wash ington.edu
      (replace x with u to respond)
      Puget Sound Oracle Users Group
      PSOUG.org - Oracle PL/SQL Database Code Library and Resources | Examples | Syntax | DBMS Packages | PL/SQL | SQL |
      https://www.psoug.org
      Oracle PL/SQL examples, syntax, DBMS packages, string, timestamp, substring, PHP code, and Javascript Code Reference Library (formerly known as Morgan's Library)

        Comment

        • Dan Guzman
          #3
          Re: DTS w/ Oracle Issue

          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_I NVOICE_ID")
          FROM "MYSCHEMA"."INV OICES" I;

          --
          Hope this helps.

          Dan Guzman
          SQL Server MVP

          "Jimbo" <jamesferris@ho tmail.comwrote in message
          news:1180626867 .763717.260180@ j4g2000prf.goog legroups.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
          >

            Comment

            • Jimbo
              #4
              Re: DTS w/ Oracle Issue

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

              -Jim

                Comment

                Previous template Next
                Working...