I've tried this and users still get the following error.

Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1

the xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify...

I've tried this and users still get the following error.

Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1

the xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify...

Gotcha. thank you!

How do you do it for all packages that are owned by domain\xyz, without having to do it one by one? If I use

update sysdtspackages

set owner_sid = SUSER_SID('DOMAIN\New_User'),

owner =...

Rather than beating my head over this, I did the "unorthadoxed" and changed the system stored proc sp_add_dtspackage.

That may be the trick having the network guys look at the original paths now.

Thank you so much!

Thank you so much! An article is a great idea! 😀

Yes, this is the Legacy DTS Packages on sql server 2k5. If they are db_owner, do they still need that permission?

It works for sa users, not for Windows Authenticated users. 🙁 They get this error.

OLE DB provider "SQLNCLI" for linked server "ServerName" returned message "Communication link failure".

Msg 10054, Level 16,...

It does have a datetime stamp.

the following code means???

DECLARE @Date DATETIME

--Select last update date

SELECT @Date = MAX(DateUpdated) FROM myTable

--If last update date is less than today

IF @Date > DATEADD(d, -1,...

Try to see if any of these solutions help.

http://www.sqlservercentral.com/Forums/Topic455426-146-2.aspx#bm459710

Thank you so much all!

So if we have a cluster and want a DR recovery site, which would be better, Mirroring or Log Shiping. I know mirroring may be easier to set up but...

Did you try checking the logs?

i found the answer, I had to create a credential and a proxy. thank you though!

http://msdn2.microsoft.com/en-us/library/ms187901.aspx 😀