Hi ,

I found that if we use the same DTS the ~P

field (I assume that it is password ) only changes.

DTSRun /

~S 0x48680976FBA2429AE6548F959D34ABC80FCA268F158812A0 /

~U 0xF8141F8065D98248 /

~P 0x2921675182DD69D9007103D19E46EAB2 /

~N 0xEF81FBEFE60680AA795A4158168EFA7F8AF5D207BB801A3BD4037AB75DDBD5BCA785A393E51D35C8C86DEE6A9014830275D32CBB6BA753FF

If...

Hi,

I assume that we can get this inforamtion from some system tables in MSDB.I think sysdtspackages is a good guess.

regards

Elias

I think the Problem is with SQL Agent. Make sure that the Account used to Start the SQL Agent has got Admin Rights on the Local Box. As ...

try to use sp_recompile WITH RECOMPILE option.

this will recompile the Stored procedure every time it is excecuted.this will solw your process but once you get the desired result...

Brendon is right. The Issue your Scheduled job is failing because the SQL server agent does not have enough Privileges on the cal Box where SQL server is...