Very Urgent!!!! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Very Urgent!!!!

Hi while executing DTS I am facing an error as mentioned below…anyonwe please respond Executed as user: USsrvc_dss_olap. …tart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14) Error string: OLE DB provider ‘MSDAORA’ reported an error. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 7399 (1CE7) Error string: OLE DB provider ‘MSDAORA’ reported an error. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217900 (80040E14); Provider Error: 7300 (1C84) Error string: OLE DB error trace [OLE/DB Provider ‘MSDAORA’ IDBInitialize::Initialize returned 0x80004005: ]. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217900 (80040E14); Provider Error: 7312 (1C90) Error string: [OLE/DB provider ret… Process Exit Code 1. The step failed.
Check these KBAs and come back:
http://support.microsoft.com/kb/814398
http://support.microsoft.com/default.aspx/kb/241267 Ensure the correct or relevant Oracle drivers are installed on the machine where this DTS package is executed and also ensure to have valid entry under TNSNAME.ORA file. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Satya,
Thanks for your prompt response. Anyhow the issue was resolved actually it seems that the prblm was due to expired login used with in the DTS for connecting a linked oracle server.
Today again we are facing another issue related to DTS, the error message is as follows,
Executed as user: DBSW007SYSTEM. …ecuting… DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5 DTSRun OnError: DTSStep_DTSExecuteSQLTask_5, Error = -2147217833 (80040E57) Error string: The statement has been terminated. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217833 (80040E57); Provider Error: 3621 (E25) Error string: The statement has been terminated. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217833 (80040E57); Provi. The step failed. Kindly provide ur valuable suggestions also incase if u have any link for DTS related issues references please update me.
You have to look at that DTS package log to know more information on this error. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>