Post reply

System::ErrorDescription

  • October 24, 2008 at 3:10 pm

    #200358

    Hi,

    I am trying to insert in a log table when the OnError EventHandler is trigger. What is the data type of this variable? Each time the insert is fire, it's failed, and this seems to be related to the System::ErrorDescription parameter.

    How I can use it to be able to insert in a table?

    Thanks,

    Rem

  • October 26, 2008 at 6:46 pm

    #889802

    System::ErrorDescription is a String, so you'll need a varchar/nvarchar column.

    What was the exact error? I've seen a few things that can cause problems with that parameter.

  • October 27, 2008 at 7:32 am

    #889971

    I have following steps:

    http://www.dushu.de/englishbook/wrox.expert.sql.server.2005.integration.services/final/bbl0043.html

    But each time I face an error, the OnError event handler failed. Is it because the definition of "[System::ErrorDescription]" in my table is not long enough? I saw somewhere that we can't have a variable longer then varchar (4000), it is true?

    How I can log the information in a table?

    Thanks,

  • October 27, 2008 at 8:57 am

    #890036

    Okay, I might have found a work around byy using variable.

    Rem

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

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