handling connection errors gracefully RRS feed

  • Question

  • I have an SSIS package that has a flat file connection manager with a path to a pc on our network like this \\deforest\logfile.  If that particular computer is not up and running naturally my package fails.  How can I capture errors in the connection manager, write them to a log and/or send an email and exit gracefully out of the package?

    Exact Error I am receiving:

    Validation error. DeForest Connection manager "Energy Data": The file name \\deforest\logfile specified in the connection was not valid.

    (I am using VS2008 Pro.)

    • Moved by Sean Jenkin Tuesday, August 9, 2011 7:04 PM (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
    Tuesday, August 9, 2011 2:00 PM


All replies