SSIS Loop for SQL instances problem RRS feed

  • Question

  • I have several SSIS packages that loop to find instance permissions.  The problem I am having is some of the instances that are being processed in the loop are offline so I when I run the package in a job it fails or is incomplete because of the task failure.  When I run the package interactively through BIDS it is successful because I am masking errors.  I was thinking about doing a pre loop to find out which instances are online so there would be no failures in the package. 

    Would it be best to run a pre-loop?  Or have a "on failure" flow that inserts the failed instance to a table? 

    Friday, June 14, 2019 2:05 PM

All replies