Handle Login Timeout in SSIS

• Eric B-295769

  SSC Veteran

  Points: 297

  More actions

  August 4, 2008 at 9:27 am

  #382120

  I have a SSIS pckage that gathers info from a list of servers. If a server is not running when the package runs the package fails.

  Is there a way to trap this, possibly store some value to denote the occurance, and allow the rest of the package to complete?

  I've tried simply running the error output from the OLE DB Source to a derived Column and into a Destination, but this does not seem to handle the login timeout issue.

  If I've left out any critical details please let me know.

  Thanks,

  EB

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  August 6, 2008 at 7:08 am

  #853782

  You have to handle connection issues in the Control Flow - not the Data Flow. When a data flow component reaches it's pre-execute phase, the connections it uses are checked and some data is cached. This can be managed a bit by the DelayValidation property - this will validate when you reach the component in the control flow. You can use the error control flow from the component to deal with these connection issues - or you can use the error handler tab.