Home Forums SQL Server 2005 SQL Server 2005 Integration Services Staging table population RE: Staging table population
Bruce W Cassidy
SSChampion
Points: 12668
More actions
February 4, 2009 at 1:21 pm
#938353
[font="Verdana"]It can depend on the indexes on the table you are inserting into as well. If it is heavily indexes, this will slow down the insert.
Try dropping all but clustered index, inserting, recreating other indexes.
[/font]