Post reply

Cursors are not supported on a table which has a clustered columnstore index

  • November 21, 2018 at 10:05 am

    #2014262

    2012

  • November 21, 2018 at 10:41 am

    #2014269

    Michael L John - Wednesday, November 21, 2018 9:01 AM

    irehman - Wednesday, November 21, 2018 8:57 AM

    Hello,

    I'm using OLE DB connection in SSIS, which inserts the data into SQL Server Table. I'm follwing getting error
    "Cursors are not supported on a table which has a clustered columnstore index".
    How do I resolve that?

    Appreciate your help.

    Stop using a cursor!

    Heh... stop using SSIS. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 9, 2019 at 1:36 am

    #3638746

    In case anyone else comes up against this problem, the solution for me was to make sure my destination was set to bulk load the table. In other words, make sure 'Table or view - fast load' is selected in the Data access mode drop down.

  • May 9, 2019 at 1:45 am

    #3638755

    Dally Horton wrote:

    In case anyone else comes up against this problem, the solution for me was to make sure my destination was set to bulk load the table. In other words, make sure 'Table or view - fast load' is selected in the Data access mode drop down.

     

    I'll probably never be in a position to test that but that's a pretty cool work around.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 9, 2019 at 1:47 am

    #3638756

    irehman wrote:

    2012

    I know you didn't originally get the answer you wanted and we had a little fun with it but that's no reason to destroy your original post.  That's also the reason why I always quote original posts if no one else has.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 16 through 19 (of 19 total)

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