SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


No comments.

Leave a Comment

Please register or log in to leave a comment.