FTP Task Gives Key Not Valid When Ran as Job

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

FTP Task Gives Key Not Valid When Ran as Job

Author

Topic

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2013-02-15 : 17:25:24

Hi everyone,
This is SSIS 2008 R2

I have an urgent issue that I'm struggling with.

This package has an FTP task and I'm using a Script task for the password to the FTP site. It works perfectly when I run it in Design/Debug mode

When ran as an Agent Job, this happens:

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.

Thanks very much for any help.
Jack

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-16 : 02:51:41

I think its because of the protection level set. The best thing would be to add password as a configuration item and pass value through it

see the example below i've done here where i created a variable for passing the password and made it a configurable item

http://visakhm.blogspot.in/2012/12/implementing-dynamic-secure-ftp-process.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources