Try/Catch for SQL Server

[cutehappybear]

Hello everyone,

I have a workflow which outputs data to several SQL tables in different SQL servers.

If one of those sql servers goes down for some reason, my workflow gives an error and at best, I can receive an email letting me know.

Is there any way in which if one of the sql servers go down, I can still output to my other sql servers tables?

[RolandSchubert]

Hi @cutehappybear ,

just an idea and not a fully elaborated solution - you can create a list of "active/responsive" servers on your network using  SQLCMD -L (command line tool, has to be called using RUN COMMAND).

You could check this list against your target servers and write only, if server is included in the list.

What do you think?

Best,

Roland