Post reply

Debug SSIS

  • May 12, 2011 at 11:35 am

    #250884

    I hope I am posting this in the right forum. Tried posting it on another forum but did not get any reply. I have an ssis package that shows an error:

    "component "Insert" (2320)" wrote 0 rows.

    The Execution method succeeded, but the number of errors raised (7) reached the maximum allowed (1); resulting in failure

    How do i debug this?

    Thanks.

  • May 12, 2011 at 12:05 pm

    #1323893

    look farther up in the output text. you should see an error that tells you exactly where it had the problem.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • May 12, 2011 at 12:27 pm

    #1323908

    ramadesai108 (5/12/2011)

    I hope I am posting this in the right forum.

    The correct forum is here: http://www.sqlservercentral.com/Forums/Forum148-1.aspx

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • May 12, 2011 at 2:10 pm

    #1323961

    Thanks for the link. I looked further in the output window and I only saw generic message that I posted earlier. I will post this issue now on the integration forms.

    Thanks.

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

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