SQL Agent Job Failure with FTP Connection

There are hundreds of post on this topic but I just ran into this problem recently so I thought I should add one more.  I created a package that sends a flat file to an FTP.  The package runs fine in BIDS but when you deploy and try and run from a SQL Agent job it fails.  Here’s a segment of the error:

Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed  .  End Error

There’s actually a very simple solution to this problem.  By default SSIS makes you package level encryption EncryptSensitiveWithUserKey.  Some of the first posts I saw said to change encryption to DontSaveSensitive, but in testing I actually got a very similar error.  The other option I saw was to try EncryptSensitiveWithPassword.  Success!  That did the trick.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s