I have an SSIS package that;
1.Runs a SP to gathers data
2. pushs this data to a CSV file
3. Sends an internal email to the company to show location and sucess of new report generated.
4. FTP's this information to another company site.
Steps 1 to 3 run fine.
I have an issue now with step 4.
I get the following error:
Description: Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B
"Key not valid for use in specified state.". 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.
the Protection level on Security is at DontSaveSensitive in Visual Studio settings.
on the Job that i created on MS, i have set the config file to a perticular location.
The config file is in that location.
but i'm still getting this error.
This job has ran with out error previously.
This was set up by someone else.
I ammended the job by adding on the email capability.
I wonder now, because i uploaded the package, are my credentials causing a problem?
I was also thinking about setting secrutiy Protection level to '''Encrypt Sensitive with user Key''
And adding a password, but i'm not sure if that is fixing the issue or just covering up the issue?
It should in theroy run ok as i have the FTP setting saved in the declaried config file?
Can any one please help on this?