Post reply

SSIS Testing in VS2015 - Server Does Not Exist

  • January 24, 2017 at 9:02 am

    #339619

    I have a project deployment SSIS project that I am creating and testing in VS2015. The single SSIS package in this project deletes all the data in my destination database and then copies data table by table from my source database to my destination database.

    I use project parameters for my source SQL-Server and destination SQL-Server.

    The package works as expected, but now I am trying to test my OnError Event Handler which sends an e-mail alerting me of the error details. This is also working well if say I misspell the name of a table in my delete sql.

    However, I figured I would test either the source or destination sql-server being down by changing my project parameters and misspelling the Source or Destination Server. VS does not trigger the OnError Event, instead, I get a Package Validation Error Dialog Box.
    So my question is, can I force VS to ignore the Package Validation and try to execute the Package anyway. I want the execution to fail and just trigger an error event.

  • January 24, 2017 at 9:09 am

    #1924654

    Yes, there is a property value on your task called DelayValidation. If you put that the TRUE, it won't check until it gets to the that task in the Task Flow.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • January 24, 2017 at 9:14 am

    #1924657

    Raymond.Pietrzak - Tuesday, January 24, 2017 9:02 AM

    I have a project deployment SSIS project that I am creating and testing in VS2015. The single SSIS package in this project deletes all the data in my destination database and then copies data table by table from my source database to my destination database.

    I use project parameters for my source SQL-Server and destination SQL-Server.

    The package works as expected, but now I am trying to test my OnError Event Handler which sends an e-mail alerting me of the error details. This is also working well if say I misspell the name of a table in my delete sql.

    However, I figured I would test either the source or destination sql-server being down by changing my project parameters and misspelling the Source or Destination Server. VS does not trigger the OnError Event, instead, I get a Package Validation Error Dialog Box.
    So my question is, can I force VS to ignore the Package Validation and try to execute the Package anyway. I want the execution to fail and just trigger an error event.

    Thanks, that worked.

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

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