Post reply

DTS package failed

  • 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 4 posts - 1 through 5 (of 5 total)

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