October 15, 2014 at 1:19 am
I have a SSIS package set up that will transfer a file from a location on the network drive and transfer it over FTP to another location.
When I manually run the package, the file is transfer with no errors. But when the job is automated (via Job Activity Monitor) the transfer fails, any ideas?
I have set the ProtectionLevel of the package to "EncryptSensitiveWithUserKey" and also converted the package to a Development Model. The settings for the FTP is saved within the package.
What am I missing? below is the error message
Executed as user: UHB\InfoSQLAgent. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 08:43:02 Error: 2014-10-13 08:43:03.72 Code: 0xC001405F Source: ResearchWebsite Description: Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information. End Error Error: 2014-10-13 08:43:25.71 Code: 0xC001602A Source: ResearchWebsite Connection manager "FTP Connection Manager" Description: An error occurred in the requested FTP operation. Detailed error description: A connection with the server could not be established End Error Error: 2014-10-13 08:43:25.71 Code: 0xC002918F Source: FTP Task FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 08:43:02 Finished: 08:43:25 Elapsed: 22.932 seconds. The package execution failed. The step failed.
October 15, 2014 at 2:41 pm
Sounds like a permission issue to me. But posting the actual error may help.
October 16, 2014 at 8:37 am
sql-lover (10/15/2014)
Sounds like a permission issue to me. But posting the actual error may help.
This is the error message
Executed as user: UHB\infoSQLExec. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 15:35:55 Error: 2014-10-16 15:35:55.77 Code: 0xC0016016 Source: ResearchWebsite 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. End Error Error: 2014-10-16 15:36:17.34 Code: 0xC001602A Source: ResearchWebsite Connection manager "FTPConnectionManager" Description: An error occurred in the requested FTP operation. Detailed error description: A connection with the server could not be established End Error Error: 2014-10-16 15:36:17.34 Code: 0xC002918F Source: FTP Task FTP Task Description: Unable to connect to FTP server using "FTPConnectionManager". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 15:35:55 Finished: 15:36:17 Elapsed: 22.09 seconds. The package execution failed. The step failed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply