No, I haven't. I've never needed to revert. But even though that wizard is out there, I'm sure it can't revert everything.

There are a lot of...

Yeah, unfortunately you can't move a 2005 database to 2000 without a lot of work. Even then, something will probably fail.

Kimberly Tripp (works for MS) actually said this about...

But in your previous post, you said you're writing "TO" SQL Server 2000. And that is what seems to be the problem to me. Check your destination source...

MP,

You should be aware of everything.

Are your Servers names actually changing? What about share folder names? Instance names? DNS names / pointers? Permissions?

If you're going to...

The first 15-30 minutes of my day are checking the jobs, making sure all of them ran correctly. This determines how the rest of my day goes.

If jobs failed...

You really should look at Books Online, topics: Fixed Database Roles and Fixed Server Roles. This will give you a listing of all available permissions that are already set...

I don't know. I think the best way to secure the Server against everyone is to unplug the darn thing and lock it in a closet.

Of course...

I'm a little confused. Why are you upgrading DTS to SSIS if you're still using SQL Server 2000 and not upgrading your database to 2005? If you're not...

I disagree. Certification helped me get my current job.

Of course, my college degree had nothing to do with computers. Neither did my paid work experience, so...

What tool are you using? The DTS Import / Export Wizard or SSIS? From which Server are you initiating the move, 2000 or 2005?

Jason,

I'm so glad you figured it out. I was at a loss myself.

Was this particular DB an upgraded one or a fresh install? If upgraded, probably...

Joel,

I honestly didn't check. I just ran a normal tuning Profiler trace against our production DB during business hours and then ran the DTA against that. I wasn't...

Mark,

I suggest you try it both ways and run Profiler on both runs. That will tell you right there which is the faster and better one for your specific...

Has anyone ever encountered the problem I've described in the post above? Any information on DTA would be greatly appreciated.

I don't even know why it didn't install properly in...

I agree that the variable is better and faster, but I wanted to put an alternate suggestion out there just in case.