You can get virtually the same functionality for DTS in SQL 2005 as in SQL 2000.  I have done this and it works.

First, you must have the DTS Designer components installed.

Second,...

I think I am getting close to why SAC does not display all services.  It looks to be a permissions issue, but I have not yet completely identified the cause.

Recently...

What type of proxy did you create?  SQL 2005 has lots of different proxies and you need to create the right one.  Also, you only need to create proxies...

The install media for SQL Server 2005 is split into 2 - a Server folder and a Tools folder.  If you do a server components install the tools will not...

If you run SQL Server 2005 32-bit on a 32-bit OS, the same rules apply as for SQL Server 2000 32-bit for /3GB, /PAE in the OS and AWE in SQL. ...

I have not played with importing DTS to SSIS, but I have used DTS Designer in SQL 2005.  I think the two ways of doing this are mutually exclusive -...

Use EM, right-click on the instance and select Properties.  If you see Product Version 8.00.2187 (SP4) you know you have the Hotfix Rollup level 2187 applied on top of SP4. ...

What fix level are you on?  If you are using SQL 2000 SP4, get the latest Hotfix rollup.  SP4 introduced a new bug that prevents SQL using more than half...

I have used 'full function' enterprise job schedulers in the past, such as IBM OPC/A and BMC CTRL-M.  I have also seen Tivoli and CA job scheduling in action, but have...

It is (relatively) easy enough to add extra steps to the end of each job that would interrogate some schedule information and start the next job in sequence, but it...

What would be FAR better is for Agent to support dependencies between jobs, and job suites.

With dependencies, you could chain jobs together, so that job B automatically starts after job...

The interface from the main SQL Server engine to Service Broker is T-SQL, so just run the relevant T_SQL statements in your .Net application.  They can be either traditional dynamic SQL or...

What type of proxy did you create?  SQL 2005 has lots of different proxies and you need to create the right one.  Also, you only need to create proxies if...

If you want to restore your database to what it was like a few days ago, you will need a backup from that time to restore it to.

It does not...

I think the behaviour is by design.  You can change the package owner if you need to.  However, the package creator is stored within the DTS object and cannot be...