Local packages are stored in the sysdtspackages table in msdb.  You can restore packages by restoring msdb.

Greg

We run DTS packages on either the source or destination server (usually the destination) to reduce network load.  If you run the package from a third server, the data will...

Open the package in DTS Designer.  On the toolbar, click Package then Save As... and put in the name of the other server before clicking OK.

Greg

That's why you backup the system databases.  You can't restore a single table, but you can restore the entire database.  See "Resoring msdb database" in BOL for details.

Greg

You'll get that error message if the destination SQL Server is started under a domain account that does not have local administrator privileges on the source computer.  

"Failed to create the...

Jonathan's insert statement will still work if you qualify the table names with the server name and database name thusly: servername.databasename.tablename

I believe you still need to have a linked server...

This is the code I use in an Execute SQL task where I'm joining 2 tables and updating where columns are changed:

UPDATE dest.dbo.table

set   col1 = s.col1,

      col2 = s.col2,    

     ...

I think the wizard uses the path that the Model database uses for it's files.  You're probably better off creating the database before using the DTS wizard so you can...

Check out the sysobjects table.  Sysconstraints is a view on that table.  You'll want to look at the xtype column in sysobjects (see Books OnLine for the list of xtype...

Try using the DTS export wizard.  Select the "Copy objects and data between SQL Server databases".  In Advanced Copy Options, you can check "Copy database users and database roles" and...

When you say design, I assume you're talking about data and database design, not application design.  My DA/DBA group works with developers and, because there are four of us and...

The only reason you'd have to explicity grant permissions to idbdocs_user is if you had removed permissions from the guest user and public role in msdb.

By default, guest is a...

The only ways I know are to upgrade in place on the same server or save all packages as structured storage files.  Unfortunately, you can't restore a backup of a...

Micah,

It sounds like you've got the right idea.  I would use a Transform Data task to copy the data, since an Execute SQL task can only use one connection. 

If...

Since a scheduled package runs under the security context of the Windows login designated as the SQL Service startup account, make sure that that login has permission to access the...