SSIS Verify if SQL instance is up

See more:

VBScript

SQL

SSIS

BI

I am currently creating a package that uses a dynamic Connection string. The values used in the connection string are pulled from a SQL table So they change on each run of my foreachloop. I would like to have it set up so that if a server is offline or the SQL instance is down the connection would skip that and move on to the next step.

What can i do to update this so i can move forward on the failures

Here is what i have so far that just verifies the success of the connection.

Public Sub Main()
      '
      '
      Dim ConnectionString As String

      ConnectionString = Dts.Variables("User::ConnectionString1").Value.ToString()
      
      '
      Dts.TaskResult = ScriptResults.Success
      '

  End Sub