Home Forums Data Warehousing Integration Services drop and create INDEX in ETL RE: drop and create INDEX in ETL

  • December 10, 2013 at 12:47 am

    #1672217

    abhas (12/10/2013)

    Hi All,

    I am siply loading and updating data from one table to another.But data is huge and number of column are also high. So i want to drop index initially and once data is loaded then i need create index on that table. In the target table there is no primary key.

    How can i aschieve this? please suggest ideas.

    Thanks

    Abhas.

    No magic required:

    1) ExecuteSQL task to drop index.

    2) Dataflow task to load data.

    3) ExecuteSQL task to create index.