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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

2 Answers

·
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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

parun avatar image parun commented ·
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 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
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
Toggle Comment visibility. Current Visibility: Viewable by all users

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.