Hi,
I have one SSIS package that has proxyaccount as owner, It is sch. to run once every day as job with same proxyaccount as job owner.
First time when I Save package and Import to MSDB and job will run successfully.
Next day again job will fail. Again I go back to package and place pw to DB connection save and import package and job will succeed.
Job history shows this error
Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. Description: "Login failed for user 'abc_data'."
Any thought or suggestion will be a great help.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com