September 21, 2012 at 11:31 pm
Hi friends,
i have tried to schedule the ssis package using agent job.
1.i have created job
2.created step and associated package to that
3.created scheduler
when trying to execute the job its showing error
in log file
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.1600.22 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 8:14:49 PM
Error: 2010-01-16 20:14:49.65
Code: 0xC0016016
Source:
Description: Failed to decrypt protected XML node "DTS:Password" 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: 2010-01-16 20:14:49.76
Code: 0xC0202009
Source: Package Connection manager "SQLSERVER\SQLSERVER.Aug12_sathiyan.apr12_sathiyan"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'apr12_sathiyan'.".
End Error
Error: 2010-01-16 20:14:49.76
Code: 0xC020801C
Source: Data Flow Task OLE DB Source [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SQLSERVER\SQLSERVER.Aug12_sathiyan.apr12_sathiyan" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
End Error
Error: 2010-01-16 20:14:49.76
Code: 0xC0047017
Source: Data Flow Task SSIS.Pipeline
Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
End Error
Error: 2010-01-16 20:14:49.76
Code: 0xC004700C
Source: Data Flow Task SSIS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2010-01-16 20:14:49.76
Code: 0xC0024107
Source: Data Flow Task
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 8:14:49 PM
Finished: 8:14:49 PM
Elapsed: 0.14 seconds
any suggestions....
thanks and regards
sathiyan
September 22, 2012 at 10:55 am
Hi friends,
I referred some posts and solved the previous problem....but it is working only without package configuration.
if my package include package configuration then the agent job is failed.
I used protection level as encryptallwithpassword.
Following error message it shows in log file:
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'apr12_sathiyan'.".
End Error
Error: 2010-01-17 08:01:32.39
Code: 0xC020801C
Source: Data Flow Task OLE DB Source [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SQLSERVER\SQLSERVER.Aug12_sathiyan.apr12_sathiyan" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
September 22, 2012 at 1:09 pm
I would think the important part of the error message is this - 'Login failed for user 'apr12_sathiyan'.".
'
Check the SQL errorlog at the time the package ran for more information as to why the login failed
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply