April 17, 2008 at 2:19 pm
I have a package that is saved on the file system. It gets data from Oracle and puts it into a SQL Server table. The package runs successfully using the dtexec utility in a DOS command window, however, when I have the same exact command in a step in a SQL Agent Job - it fails with the following:
...1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:04:01 PM Error: 2008-04-17 16:04:01.09 Code: 0xC001405F Source: Description: Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information. End Error Progress: 2008-04-17 16:04:01.29 Source: Data Flow Task Validating: 0% complete End Progress Error: 2008-04-17 16:04:01.64 Code: 0xC0047062 Source: Data Flow Task Source - Query [1] Description: System.Data.OracleClient.OracleException: ORA-01005: null password given; logon denied at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boole... Process Exit Code 1. The step failed.
Why is it passing null credentials to Oracle when running from within a job? How can this be remedied?
April 17, 2008 at 2:34 pm
Now when I run it in the DOS window - I get the same error -- null password given; logon failed. Why does it not pass the password that is indicated in the package? The package was created using the Import Data Wizard.
April 17, 2008 at 4:48 pm
It most likely fails when run in a job step because the package is run by the login that runs SQL Server Agent, which is not the login that created the package. This may help:
http://support.microsoft.com/kb/918760/en-us
Greg
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply