I also tried from 2000 enterprise to 2005 standard and had the same problem.

Going from SQL 2000 Enterprise to SQL 2005 Enterprise. Both 32 bit.

I am sorry when I said upgrade I meant and in-place upgrade.

This is what I found from a little more digging.

Can I do an "in-place" upgrade on the x64 OS?

Well, it certainly has been awhile since my last blog. In...

I don't think you are doing anything wrong.  It seems DTS will not allow you to change the lengths or add columns other than what is in the source.  You...

This may help.  It is not glamorous but it should do the trick.

declare @OrderNumber int, @PrevOrderNumber int

declare @OrderType Varchar(10),@PrevOrderType Varchar(10)

declare @LineNumber int,@PrevLineNumber int

declare @refs...

Just a comment on the use of AWE. I have a server with 8gb or ram. I used the /3gb and /pae together and this caused me a...