How to Fix Warning: 0x80019002?

  • I installed SQL 2005 Dev verision from MSDN DVD.  There is a problem that I don't know how to fix; google has almost little help with this problem.  I followed tutorials in BOL to create first SSIS package.  When debugging I always got the package failed:


    Warning: 0x80019002 at Lesson 1: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

    SSIS package "Lesson 1.dtsx" finished: Failure.


    Anyone has this problem?  I installed SQL 2005 on another computer and still got the same warning.  Thx.

  • You need to look in the "Progress" tab if the package is running or in the "Execution Results" tab if the project has stopped. Scroll up on the screen, above the message you've described and look for a red "X" that will have a more detailed and more specific error message. Then we can figure out what went wrong.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 2 (of 2 total)

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