Sql Server Agent
Posted on 2011-10-04
I have SSIS package in sql server 2005, it works fine, but in sql server agent gives me error
that SSiS Package has script task and FTP task, Thanks
Executed as user: t1\SYSTEM. ...on 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:14:58 PM Error: 2011-10-04 16:14:58.49 Code: 0xC0016016 Source: 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: 2011-10-04 16:14:59.18 Code: 0xC001602A Source: Members Connection manager "FTP Connection Manager" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed . End Error Error: 2011-10-04 16:14:59.20 Code: 0xC002918F Source: FTP M1XML FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager". End Error DTExec: The pa... The package execution fa... The step failed.