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