Unfortunately this Application vendor only wants SP1 for this project - all our other SQL 2005 servers are sp2 + hot fixes.

Thanks for the info - will open a case tomorrow...

I am also about to undertake the exact same task, I have done these in DTS but this will be my first SSIS package. Any hints would be appreciated.

Mao

This is what we would do in this situation - this is from some internal doco - with a few changes for the outside world.

It also assumes that you have recovery...