error Message :
Description: Failed to decrypt protected XML node "DTS:Password" 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
I've had the same error and just solved it.
As well as changing the protection level of the packages to DontSaveSensitive,
you also need to make sure that anywhere within the package that points
to a network drive i.e. all connection managers, and within any execute
package containers, all the the file paths do not start off with the
letter of the drive, instead use the server name.
i.e. K:\foldername\inputfile.xls
becomes: -
\\ServerName\foldername\inputfile.xls
No comments:
Post a Comment