Post reply

Creating SSIS Package Event Handlers

  • September 11, 2007 at 12:53 pm

    #153816

    I would like to create an event handler that would catch any errors that result from a sys.

    not existing. The package is designed to run on both SQL Server 2000 and SQL Server 2005 and when I query sys. there is an error when the query is run on SQL Server 2000. I just need a good starting point...I would like something that when the server isn't 2005 it just skips the server and doesn't fail the package and doesn't get counted towards the max error count. Thanks for any help.

    -Kyle

     

  • September 11, 2007 at 2:48 pm

    #732916

    Either

    1.) just use the old names ex. SysObject, SysColumns, etc

    or

    2.)

    If Object_ID('sys.objects') Is Not Null

    EXEC('select * From sys.objects')

    Else

    EXEC('select * From sysobjects')

  • September 11, 2007 at 2:50 pm

    #732917

    I was more wondering what control flow item I use under the Event Handlers Tab?

    -Kyle

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

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