More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What is the quickest way to get them working?
You have just installed a 64-bit SQL Server 2005 instance and want to move all your SQL Server 2005 data to this new instance. You wish to migrate your DTS packages, but they do not seem to run. What is the quickest way to get them working?
Answer: Rewrite them using SSIS.
Explanation: There is no 64-bit support for DTS packages. They must be rewritten in SSIS on a 32-bit computer and compiled for 64-bit execution.
(Continued on next question...)