question

parun avatar image
parun asked

SSIS package running through sql server procedure ERRoR how to slove the Problem

Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. NULL Started: 11:01:33 AM Error: 2012-11-05 11:01:33.13 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: 2012-11-05 11:01:33.21 Code: 0xC001602A Source: Package 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: 2012-11-05 11:01:33.21 Code: 0xC002918F Source: FTP Task FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager". End Error Warning: 2012-11-05 11:01:33.21 Code: 0x80019002 Source: Package Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:01:33 AM Finished: 11:01:33 AM Elapsed: 0.125 seconds
ssispasswordftp
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
Looks like its a password issue. > " ... Detailed error description: The password was not allowed." A quick search for that error brings back this as one of the possible solutions: http://www.proteanit.com/b/2008/02/13/ssis-ftp-task-code-to-set-the-password/.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

viusal studio itself execute fine and command prompt running fine but am create store procedure and calling packages running itself it get error
0 Likes 0 ·
and I believe that the scenario you describe is covered in the link I provided
0 Likes 0 ·
parun avatar image
parun answered
thank you my Senior
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.