Click here to Skip to main content
14,385,111 members
Rate this:
Please Sign up or sign in to vote.
See more:
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
Updated 29-Dec-15 5:53am
dharan1990 21-Jan-16 9:14am
You have forloop container and some tasks inside it you want to test the sql connections before running the task inside the forloop is that what you are looking for?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100