You can set the data source dynamically using the Dynamic Properties task. Typically you would assign the desired connection value to a global variable(s) and then use the Dynamic Properties Task to change the Data Source and/or (depending on the type of db being used) Catalog properties on the connection at run time.