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 |
|
lalbatros
Yak Posting Veteran
69 Posts |
 Posted - 2008-04-13 : 05:15:28
|
| HelloMy IT collegues migrated my database from SqlServer 2000 to SqlServer 2005.I installed the "Microsoft SQL Server 2005 Express Edition with Advanced Services" with the hope to restore everything in a couple of hours.Unfortunately, I could not find out where my jobs and my DTS are.What should I install to be able to manage my jobs and my DTS again?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-13 : 08:54:21
|
| You can find your dts packages in SQL Management Studio under Management > Legacy > Data Transformation Services |
 |
|
|
lalbatros
Yak Posting Veteran
69 Posts |
Posted - 2008-04-13 : 15:13:56
|
| Thanks visakh16.Does that mean that "Microsoft SQL Server 2005 Express Edition with Advanced Services" is not enough.(I looked under "Management" and found no legacy item)And would you have a hint about my jobs?Thanks in advance. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-13 : 15:53:28
|
| You are right, it doesn't support sql agent. You need sql2k5 workgroup edition at least. |
|
|
|
|
|
|
migrated to 2005: where are my jobs and my dts?