Do you mean the object browser?  Either press F8 or click on Tools, Object Browser, Show/hide.

Greg

An easy way to generate a DTSRUN command is to use the dtsrunui utility.  You can find instructions for it's use in BooksOnLine, but basically you run it from a...

According to "Professional SQL Server 2000 DTS", an Active-X Script task can't join the package transaction, so you wouldn't be able to rollback the transaction if the file copy failed. ...

Run this:

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

If the results look like this: '9.00.2047.00  SP1  Standard Edition', you've got SP1.

Greg

The only way I know of would be to attach the file to an existing SQL Server instance then use DTS to export to Excel or Access.

Greg

Create another connection specifying where you want to copy the file to.  Then, use a Transform Data task between the source connection and the new connection.  The csv file will...

Another option is to use DTSBackup 2000, freeware written by Darren Green.  You can transfer multiple packages and it works great.  Download it here:

http://www.sqldts.com/default.aspx?242

As for jobs, I'd script them...

Maybe this?   http://support.microsoft.com/kb/841001/en-us

Greg

Sorry, I can't be much help then.  Unless you can figure out what ExecuteDTS is doing.  Maybe it's a stored procedure that uses DTSRun?

Greg

Is the SQL2005 instance on a different domain?  It sounds like the password validation rules are different than those of the domain where the SQL2000 instance resides.

Greg

No problem.  I just set up Database Mail for the first time  myself and that's what tripped me up so I recognized the problem.

Greg

I have to admit I've never heard of executing a DTS package this way.  I thought that SQLExecute was only for SQL statements.  Have you been able to run DTS...

Carl,

Did you designate Database Mail as the mail system for SQL Server Agent?

Greg

Do you mean logins?  Users exist in databases and will be transferred when you move a database to another instance.  Moving logins between SQL 2000 and SQL 2005 instances is...

What is "Exporting Backup"?  Is it a DTS package where you're using the query in a Transform Data task?

Greg