This string works: TOKEN(TOKEN(@[User::DynamicConnectionString], ";", 1), "=", 2)

Here's a breakdown of the expression:

@[User::DynamicConnectionString]: This is the variable holding your connection string.

TOKEN(@[User::DynamicConnectionString], ";", 1): This extracts the first token from the connection string, which is Data Source=ServerName.

TOKEN(TOKEN(@[User::DynamicConnectionString], ";", 1), "=", 2): This further extracts the second token from Data Source=ServerName, which is ServerName.

Assign the Connection String: Make sure your connection string is stored in a variable, say DynamicConnectionString.