May 1, 2008 at 8:25 pm
I have created a SSIS package that takes a CSV file and FTP's the file. Once again the package works fine when run in VS2005 or in the MSDB from SQL server. When I schedule the package under SQL server, the package fails with the following error??
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: 2008-05-01 19:05:49.92 Code: 0xC001602A Source: SPED Connection manager "FTP SPED CSV" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed . End Error Error: 2008-05-01 19:05:49.92 Code: 0xC002918F Source: FTP to SPED FTP Task Description: Unable to connect to FTP server using "FTP SPED CSV". End Error DTExec: The package execution returned DTSER_FAI... The package execution fa... The step failed.
May 2, 2008 at 3:52 pm
Sounds like a password issue. If it is, here are two options.
1. Set the password for the FTP Connection in a Script Task before the FTP Task.
2. Use a package configuration file to store the password. SSIS - Configuration File
Example: Setting FTP connection password in Script Task.
Public Sub Main()
Dim myConnection As ConnectionManager
myConnection = Dts.Connections("FTP Server")
myConnection.Properties("ServerPassword").SetValue(myConnection, "mypassword")
Dts.TaskResult = Dts.Results.Success
End Sub
May 5, 2008 at 2:25 pm
Hi,
I think this is the prblem with the deployment of your package. Redeploy your package to your server, but this time make sure check the box, rely on server storage for encryption and continue with other steps and scedule it as a job.
-V
May 6, 2008 at 4:03 pm
Yes, that worked! Thanks:hehe:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply