Thanks for the solutions. I tackled this problem two years ago and I dealt with the package level error file when re-creating a DTS, but I forgot about the default...
Most of the comments have suggested that moving the data will be the easy part and that recreating the queries and code will be where to work comes in....