Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS FTP Package Fails as a Job but Runs Manually


SSIS FTP Package Fails as a Job but Runs Manually

Author
Message
homebrew01
homebrew01
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2988 Visits: 9071
I wrote an SSIS package that pulld files from a client's FTP site. When run manually through "Execute Package Utility" -> "Execute" it runs to completion.

If I try and run it in a query window
exec xp_cmdshell 'dtexec /DTS "\MSDB\Website_FTP_Import" /SERVER MySQLServer Name /CHECKPOINTING OFF  /REPORTING V '


, I get the following error, saying the password is not allowed. But the password is in the package and it works when run the other way.:

Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2520.0 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 14:25:49
Error: 2013-06-23 14:25:49.97
Code: 0xC0016016
Source:
Description: Failed to decrypt protected XML node "DTSTongueroperty" 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: 2013-06-23 14:25:54.08
Code: 0xC001602A
Source: Website_FTP_Import 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: 2013-06-23 14:25:54.08
Code: 0xC002918F
Source: FTP Task - RoundTable FTP Task
Description: Unable to connect to FTP server using "FTP Connection Manager".
End Error
Warning: 2013-06-23 14:25:54.08
Code: 0x80019002
Source: Website_FTP_Import
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 specifie
d in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 14:25:49
Finished: 14:25:54
Elapsed: 4.203 seconds
NULL





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search