Post reply

parameterised SQL for an Oracle OLE DB source

  • February 4, 2010 at 7:01 am

    #144757

    hi

    simple question with a twist

    how do i parameterise an Oracle OLE db source?

    and NO i can't use a variable, because the sql is over 4000 characters

    🙂

  • February 4, 2010 at 10:35 am

    #1113868

    darth vodka (2/4/2010)

    hi

    simple question with a twist

    how do i parameterise an Oracle OLE db source?

    and NO i can't use a variable, because the sql is over 4000 characters

    🙂

    Have you tried to create parametrized Oracle stored procedure, which you can call from OLE DB Source?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • February 5, 2010 at 2:26 am

    #1114262

    ah, good point

    but i've only got read only on the oracle server

    i've actually solved it by hacking the sql down (fun!)

    i'd still like to know if the limits of SSIS would stump me otherwise...

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

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