Have the package owner save it with a user password, give the password to the second user, and have him execute the package and provide the password when prompted. ...

Dev,

Check out DTSBackup 2000 at http://www.sqldts.com/242.aspx. It will copy all the packages in an instance. The "direct transfer" method will preserve the package layout.

Hi,

Please be more specific about what you need help with. It would be nearly impossible for anyone to give you details about everything you need to do to get...

So developers need to edit packages they don't own? I think package passwords work the same for legacy packages in SQL 2005 as they did in SQL 2000. ...

Is the ProtectionLevel of the called package set to "ServerStorage"?

Are these DTS packages or SSIS packages? Are they stored in SQL Server or in the file system?

In my experience, a "hot" backup is one made while the database is available for use as opposed to the database being closed and unavailable ("cold" backup).

I learned...

You're asking an Oracle question on a strictly SQL Server forum. You may get lucky and get help from someone here who works on both platforms, but you're more...

Yet another reason to have multiple instances on a single physical server is you can reduce your hardware inventory. We have a development instance and a demo (QA) instance...

You'd use the same update statement execept change the WHERE clause to

where owner = 'DOMAIN\Old_User'

As I said earlier in the thread, I've never had a package revert to a...

Check to see if the login that runs SQL Server Agent as permission to open the Access database. When a package is run from a job, it will use...

If you're using a Transform Data...

Maybe if they're members of db_owner in msdb, but I haven't tried that. Permissions in msdb don't work exactly like those in user databases.

We're talking about legacy DTS package, right? Members of Sysadmin and package owners can still save versions of packages in SSMS. Others would have to have execute permissions...

Matt Miller (3/20/2008That may be a 2005 vs 2000 thing. I saw DTS package and I automatically went back to EM. I will have to check a 2005...