We have a table 'Servers' which lists all the Servers in our Company.
My scenario is that we have a a Dynamic as well as static FQDN to connect to a database server.
I need the script or packgae(SSIS) to first test if we are able to connect using the static name if 'Yes' then I need to update a column 'IsConnectStatic' in a table Servers to 1 and then test connection using Dynamic name if that connection is also successful then I need to update the column 'IsConnectDynamic' column to 1.
in Servers table.
I am wondering how I can establish this logic. If I can use SSIS which SSIS task I need to use? And whiin the task how do I establish the object.