Thanks, folks!

All will be SSIS within however many months it takes me to re-write...

I agree that automating Excel can be tricky and it's been a long time since I've done it, but it seems to be really funky on early vs late binding....

Sorry to hijack, but I also am now in an environment going 2000 > 2008R2 and wonder if there is a way to script out DTS packages?

Not sure...

My advice is to keep looking.

It is short-sighted of your company to not want to take advantage of your skills, so keep shopping. There will be an organization very...