Post reply

SSIS OLE DB Error - Missing right parenthesis

  • March 8, 2013 at 7:01 pm

    #1595173

    Nevermind, I had --acct_dt = prod_dt commented out in the statement, which runs in PL/SQL but not SSIS.

  • July 13, 2018 at 12:20 am

    #1997433

    I know this topic is a little bit outdated, but it can be useful for later searches. I have run into the same problem. My resolution was to take the timestamp fields into a trunc(*timestamp*)  function. In this case ACC_DT or PROD_DT or both  is a timestamp field, not date. In database developer tools like DbVis, HORA or else it runs fine, but SSIS is a complicated one... 🙂

    Hope it helps,
    Loránd

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply