Post reply

DTS package failed

  • July 9, 2012 at 6:43 am

    #259167

    Hello, my DTS package failed this morning and I don't know what this error means:

    Executed as user: US-CRS\svchum. ...nStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14) Error string: OLE DB provider 'MSDASQL' 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 'MSDASQL' 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 'MSDASQL' IRowset::GetNextRows returned 0x80004005: ]. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -21... Process Exit Code 1. The step failed.

    Is anyway knows ?

    Thank you

  • July 10, 2012 at 3:37 am

    #1510762

    Its not a very helpful message but it tells you that the error occured in

    DTSStep_DTSExecuteSQLTask_1

    So start your search there.

    Also can you confirm that this is actually SSIS

  • July 10, 2012 at 3:57 am

    #1510775

    Is this because of nework issue over their. One thing you can do is manually run job...

  • July 10, 2012 at 4:08 am

    #1510783

    I think the error is here

    Error string: OLE DB provider 'MSDASQL' 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 'MSDASQL' IRowset::GetNextRows returned 0x80004005: ]. Error source: Microsoft OLE DB Provider for SQL Server

    So in your DTS/SSIS(as you posted in 2005), you have some invalid connection string to sql server. Can you verify the connection string in your dts.

    ----------
    Ashish

  • July 10, 2012 at 7:18 am

    #1510898

    I re ran and it worked,but I wanted to know what happend at that time.

    Thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply