Post reply

In which format i need to give in Expressions for Selected tables in Reorganize Index Task in SSIS 2008?

  • April 19, 2012 at 11:43 pm

    #256756

    Hi,

    I need to Reorganize Index in one database based on fragmentation percentage between 10 to 40.I have given database name in Reorganize Index Task in SSIS.For selected tables,I need to use expression.The question is

    In which format i need to give in Expressions for Selected tables?

    I have tried giving table1,table2,table3 but it is throwing following error

    "The result of the expression "table1,table2,table3" on property "selectedTables" cannot be written to the property.The expression was evaluated,but cannot be set on the property."

    Please give any suggestion to achieve this.

    Thanks in advance.

  • April 20, 2012 at 12:07 am

    #1476429

    Don't you have a dropdown to select the tables?

    Selectively rebuild indexes with SQL Server maintenance plans[/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 20, 2012 at 12:17 am

    #1476432

    Thanks for your reply.

    Yes in Reorganize index task we can selecttables in drop down.

    But my requirement is i need to reorganize index only for those tables having fragmentation between 10 to 40.So using execute sql task i am getting all the table names having fragmentation between 10 to 40 in to a variable.And i want to use these tables in Reorganize index task.In Reorganize index task expressions in need to give the selectedtables values.

    Thanks

    Bharath

  • April 20, 2012 at 12:32 am

    #1476433

    bharathgceb1 (4/20/2012)

    Thanks for your reply.

    Yes in Reorganize index task we can selecttables in drop down.

    But my requirement is i need to reorganize index only for those tables having fragmentation between 10 to 40.So using execute sql task i am getting all the table names having fragmentation between 10 to 40 in to a variable.And i want to use these tables in Reorganize index task.In Reorganize index task expressions in need to give the selectedtables values.

    Thanks

    Bharath

    I think it's not possible with this task. When you configure the task, you have the option to configure the TSQL. Copy that and make your own dynamic SQL script.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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