SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 migrated to 2005: where are my jobs and my dts?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lalbatros
Yak Posting Veteran

69 Posts

Posted - 04/13/2008 :  05:15:28  Show Profile  Reply with Quote
Hello

My 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

Edited by - lalbatros on 04/13/2008 05:16:39

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/13/2008 :  08:54:21  Show Profile  Reply with Quote
You can find your dts packages in SQL Management Studio under Management > Legacy > Data Transformation Services
Go to Top of Page

lalbatros
Yak Posting Veteran

69 Posts

Posted - 04/13/2008 :  15:13:56  Show Profile  Reply with Quote
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.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/13/2008 :  15:53:28  Show Profile  Reply with Quote
You are right, it doesn't support sql agent. You need sql2k5 workgroup edition at least.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000