can anybody tell me the best way to load data fast using SSIS? I'm trying to
just disable the indexes on the destination table before i truncate and then
load, but using the fast load option gives me an error saying that it was
unable to produce a plan because the clustered index is disabled.

does anybody know what's the best way to do this, because i kinda thought
disabling indexes was the best way for this kind of bulk load operation in
SSIS. I can make it work using the non last load option, but it's magnitudes
slower.

Look at this blog which compares five methods of loading files:
http://weblogs.sqlteam.com/mladenp/articles/10631.aspx

Charles Kangai, MCT, MCDBA



"crever" wrote: