Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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?
 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
52326 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  
 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.06 seconds. Powered By: Snitz Forums 2000