what he meant was your SSIS in 2012 can connect to any SQL 2000 instance, and thus do the database migration.
no need to use DTS and then SSIS if SSIS alone could do all the work.
I'd stick with the suggestions relating to restoring the database on a 2008 or R2 instance, then doing a backup and restoring that on your 2012 instance.
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!