title: Tracking down data load performance issues in SSIS package
body: <p>Are there any ways to determine what the differences in databases are that affect a SSIS package load performance ?</p>
  
  <p>I've got a package which loads and does various bits of processing on ~100k records on my laptop database in about 5 minutes</p>
  
  <p>Try the same package and same data on the test server, which is a reasonable box in both CPU and memory, and it's still running ... about 1 hour so far :-(
  Checked the package with a small set of data, and it ran through Ok </p>