SQL Server Performance

Very Urgent!!!!

Discussion in 'Analysis Services/Data Warehousing' started by Skumar, May 15, 2007.

  1. Skumar New Member

    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.
  2. satya Moderator

    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.
  3. Skumar New Member

    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.


  4. satya Moderator

    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.

Share This Page