Post reply

How to skip Deleted Servers

  • June 27, 2023 at 1:11 pm

    #4220671

    I have a SQL table with some servers and a package which runs of those servers.

    1.Execute task to list the servers from the table.

    2.For each loopcontainer inside which I have data flow task which in turn has oledbsource and oledbdestination.

    The package runs fine when all servers are present.If a server is deleted or does not exist anymore how can I ensure the SSIS package still runs.

    Thanks

  • June 28, 2023 at 2:10 pm

    #4221667

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • July 20, 2023 at 12:59 pm

    #4240102

    Event handlers allow you to handle errors and proceed with desired processing.

    1. Add an event handler to your data flow task

    Image1

    2. Open the variables pane and click on the grid options, enable show system variables.

    Image2

    3. Set the Propagate system variable to false.

    Image3

    This will allow the data flow task to error, be caught by the error handler and have the error not propagated up through the package, instead it will continue the loop processing.

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

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