Home Forums SQL Server 2005 SQL Server 2005 Integration Services No Progress while Update RE: No Progress while Update

  • September 21, 2012 at 2:37 am

    #1540523

    Koen Verbeeck (9/20/2012)

    Your mistake is in using the OLE DB Command for doing updates, which is very, very slow.

    Try writing the rows to a staging table and do an UPDATE using TSQL in an Execute SQL Task.

    Yes..Koen...If update does not work directly, i create a staging table and pushing the rows into the table and start updating from that table like you said...

    but what causes slowing the directly updating?

    Koen, May i know what could be the possible ways that i could have done mistakes while using OLEDB command component?

    Thanks,
    Charmer