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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.