Post reply

SSIS Rebuild Index Task

  • July 10, 2012 at 8:51 am

    #258812

    Hi,

    I'm using the SSIS Rebuild Index Task in one of my package and would like to understand if it's acting normally.

    Process:

    1) Disable Indexes

    2) Load ~ 16M records

    3) Run Rebuild Index Task

    Issue: The indexes are not re-enabling themselves after the task runs. Is this normal?

    Thanks

  • July 16, 2012 at 12:18 pm

    #1513248

    No. A REBUILD will rebuild the index thereby enabling it.

    Check that the Rebuild Index Task is not skipping the disabled indexes.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 16, 2012 at 12:27 pm

    #1513251

    I just tested SSIS 2008 against a 2008 R2 instance and the Rebuild Index Task picked up, rebuilt and therefore enabled a disabled index in my database.

    Please post back when you figure what's happening in your environment.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 16, 2012 at 2:28 pm

    #1513316

    I found the issue, I'm a bit ashamed of this beginner's mistake.

    The connection string of the OLEDB Component of the Index Rebuild Task had been hardcoded to our Dev environnement instead of using the environnement variable to select the connection string.

    Thanks for your time anyways.

  • July 16, 2012 at 2:41 pm

    #1513323

    Maxime.Gagne (7/16/2012)

    I found the issue, I'm a bit ashamed of this beginner's mistake.

    The connection string of the OLEDB Component of the Index Rebuild Task had been hardcoded to our Dev environnement instead of using the environnement variable to select the connection string.

    Thanks for your time anyways.

    Anytime. Working with this stuff, that or something similar catches every one of us off guard from time to time. Enjoy your day!

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 5 posts - 1 through 4 (of 4 total)

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