July 8, 2014 at 11:20 pm
i have a master package which executes 10 child packages, all the packages sharing the same configuration file. i have package configuration in each of the child packages and the master package which points to the same configuration file (where im passing the connection details with password).
when i try to schedule the master package from file system, it is failing. i tried scheduling on of the child package from the file system, it works fine. not sure why the master package alone is failing with the error saying Null password being passed. my packages use oracle data source.
find below the error message
Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:50:28 PM Error: 2014-07-08 17:50:30.35 Code: 0xC0202009 Source: Pkg_Senior_Members_Legal_Lending_Limitation Connection manager "DS_cvsystem" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005: null password given; logon denied". End Error Error: 2014-07-08 17:50:30.35 Code: 0xC020801C Source: DFT_Senior Members Legal Lending Limitation OLE DB Source [36] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DS_cvsystem" 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: 2014-07-08 17:50:30.35 Code: 0xC0047017 Source: DFT_Senior Members Legal Lending Limitation SSIS.Pipeline Description: OLE DB Source failed validation and returned error code 0xC020801C. End Error Error: 2014-07-08 17:50:30.35 Code: 0xC004700C Source: DFT_Senior Members Legal Lending Limitation SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2014-07-08 17:50:30.35 Code: 0xC0024107 Source: DFT_Senior Members Legal Lending Limitation Description: There were errors during task validation. End Error Error: 2014-07-08 17:50:30.35 Code: 0xC00220DE Source: EPT_Senior_Members_Legal_Lending_Limitation Description: Error 0xC0012050 while loading package file "D:\CBO\SSIS\CBOMIS\CBOMIS\pkg_Senior_Members_Legal_Lending_Limitation.dtsx". Package failed validation from the ExecutePackage task. The package cannot run. . End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:50:28 PM Finished: 5:50:30 PM Elapsed: 1.794 seconds. The package execution failed. The step failed.
pl let me know incase im missing something
July 10, 2014 at 7:03 am
Set Delay validation to true ...
Check connection string in Connection Manager....
its dynamic or static you have used in package with correct values or not
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply