• Don't use a T-SQL cursor to do this. Use a ForEach loop container in SSIS. You can use the results from your table to set the value of a variable, whcih you can use to set any property of the connection manager, in particular the connection string.

    John