| Author |
Topic |
|
cathy25
Starting Member
3 Posts |
 Posted - 2009-02-13 : 08:46:48
|
| Hi,we are planning on migrating our sql from version 2000 to 2005. 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 09:10:57
|
| http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1251587,00.html |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-13 : 09:29:45
|
| Connect to Integration Services and open your MSDB folder if you have migrated to it. |
|
|
|
cathy25
Starting Member
3 Posts |
Posted - 2009-02-13 : 10:13:55
|
| I am a Newbie. Could you tell me how to open up Integration Services?If I go Start -> all programs--> microsoft sql server --> I don't find any integration services in my system |
|
|
|
cathy25
Starting Member
3 Posts |
Posted - 2009-02-13 : 10:29:39
|
| I got it. I am able to find the migrated dts packages under integration services, but I am unable to open them? They are just showing blank screen besides them. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-13 : 10:48:49
|
| Open up the package in BI studio. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 11:25:29
|
quote:
Originally posted by cathy25
I got it. I am able to find the migrated dts packages under integration services, but I am unable to open them? They are just showing blank screen besides them.
you need to install sql 2000 dts designer component for editing/viewing the dts packages in sql 2005. once installed you can open them from sql management studio. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 11:26:16
|
quote:
Originally posted by sodeep
Open up the package in BI studio.
i dont think you can open dts package in BI studio unless you do conversion by means of conversion wizard. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-13 : 12:03:21
|
quote:
Originally posted by visakh16
quote:
Originally posted by sodeep
Open up the package in BI studio.
i dont think you can open dts package in BI studio unless you do conversion by means of conversion wizard.
OP already said he ran Migration Wizard to convert DTS packages to SSIS package. Please see first post. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-13 : 12:04:25
|
quote:
Originally posted by visakh16
quote:
Originally posted by cathy25
I got it. I am able to find the migrated dts packages under integration services, but I am unable to open them? They are just showing blank screen besides them.
you need to install sql 2000 dts designer component for editing/viewing the dts packages in sql 2005. once installed you can open them from sql management studio.
Also Why you need DTS package Designer when SSIS package is working. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-13 : 12:09:02
|
quote:
Originally posted by visakh16
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1251587,00.html
You don't need this unless you want to keep DTS package as it is in SQL Server 2005 |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-02-13 : 13:26:12
|
| Cathy can practice MSDN SSIS tutorials to get hands on BIDS and how to create SSIS package. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 13:33:22
|
quote:
Originally posted by sodeep
quote:
Originally posted by visakh16
quote:
Originally posted by cathy25
I got it. I am able to find the migrated dts packages under integration services, but I am unable to open them? They are just showing blank screen besides them.
you need to install sql 2000 dts designer component for editing/viewing the dts packages in sql 2005. once installed you can open them from sql management studio.
Also Why you need DTS package Designer when SSIS package is working.
not everybody would wish to convert dts to ssis. it can range from very simple tweaking to almost entire logic to be rewrtitten sometimes after conversion to get it working in same way which might prove to be a pain in a$$. so there will come situations when you choose to store them as dts package itself.i'm not talking about new packages but about maintainenece of old packages. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-13 : 14:14:49
|
quote:
Originally posted by visakh16
quote:
Originally posted by sodeep
quote:
Originally posted by visakh16
quote:
Originally posted by cathy25
I got it. I am able to find the migrated dts packages under integration services, but I am unable to open them? They are just showing blank screen besides them.
you need to install sql 2000 dts designer component for editing/viewing the dts packages in sql 2005. once installed you can open them from sql management studio.
Also Why you need DTS package Designer when SSIS package is working.
not everybody would wish to convert dts to ssis. it can range from very simple tweaking to almost entire logic to be rewrtitten sometimes after conversion to get it working in same way which might prove to be a pain in a$$. so there will come situations when you choose to store them as dts package itself.i'm not talking about new packages but about maintainenece of old packages.
I am not talking about maintaining DTS package. I am just answering what OP is asking . |
|
|
|
|
Migrating DTS Packages from SQL server 2000 to SQL