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
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