By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Migrating DTS Packages from SQL server 2000 to SQL server 2005

P: 21
Hi,
we are planning on migrating our sql from version 2000 to 2005 (I know SQL 2005 is in market from a while). As a part of testing, i have installed sql server 2005 on my development box and able to restore all databases from the production. When it came to DTS packages, I have used SSMS to migrate them by going into Management --> Legacy --> Data Transformation Services --> RC and selected Migrate Wizard. I have gone through the wizard and for tested purpose, selected 2 of my production DTS packages. the wizard ran successfully showing the success message at the end. But, I am unable to find those migrated DTS packages at Management --> Legacy --> Data Tranformation services. How can I find those two migrated packages and how can I work with them? Can't I use SSMS just like Enterprise manager in SQL 2000? Please let me know what are other diffences between SQL 2000 and SQL 2005?

TIA
Feb 12 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.