Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mathias
Posting Yak Master
119 Posts |
 Posted - 2007-03-16 : 06:15:02
|
| Hi,I have imported 3 DTS from SQL 2000 to the SQL 2005 server. The wizard went fine, everything is ok. When I close the wizard window, I cannot see any of them. If I reimport it, it asks confirmation to override it. Where are the 3 DTS in the management Studio if they are not under Legacy \ DTS?Thanks |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-17 : 02:06:43
|
| Check msdb..sysdtspackages80, if they are not there then may be saved as files...MohammedU |
 |
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2007-03-19 : 03:30:34
|
| you are right, when I doselect * from msdb..sysdtspackages90I can see them (all 3 + 2 maintenance plans), how do I make them active in the SQL 2005 management studio. I can see the 2 maintenance plans created with the wizard but not the 3 imported DTS? |
|
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-20 : 01:28:37
|
| In SQL 2005 MPs uses SSIS to run the MPs where as in 2000 it uses TSQL with help of .exe...and maintenance plan information stored in system tables...I don't know there is any option to enable it but as per the following link they are enabled by default after migration...http://msdn2.microsoft.com/en-us/library/bb153838.aspxMohammedU |
|
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2007-03-21 : 06:56:58
|
| Unfortunately, I cannot see any package under Maintenance Plans folder. Any clue?Per Microsoft specs:When the migration finishes, a SQL Server 2005 version of the plan is placed in the Maintenance Plans folder.This doens't happen. |
|
|
|
|
|
|
Cannot see DTS imported by Legacy DTS