Create a transformation that uses a Text file input step that reads the file with the connection data.

Add a Copy rows to results step to the transformation. Create a hop going from Text file input to Copy rows to results.

Create a second transformation and define the following named parameters: BRANCH, HOST_NAME, and DATABASE_NAME. Named parameters can be created by right-clicking on the transformation and selecting Transformation settings. Switch to the Parameters tab and enter the named parameters.

Create a database connection. Choose the proper Connection Type:, and fill the Settings data. Type a value for the Port Number:, the User Name:, and the Password fields. As Host Name: type ${HOST_NAME}, and as Database Name: type ${DATABASE_NAME}.

Use a Table Input step for getting the total sales from the database. Use the connection just defined.

Use a Text file output step for sending the sales summary to a text file. Don't forget to check the option Append under the Content tab of the setting window.

Create a job with two Transformation job entries, linked one after the other.

Use the first entry to call the first transformation you created and the second entry to call the second transformation. The job looks like the following:

Double-click on the second transformation entry, select the Advanced tab, and check the Copy previous results to parameters? and the Execute for every input row? checkboxes.

Select the Parameters tab and fill it as shown:

Save both transformations. Save the job and run it.

Open the generated text file. It should have one line with sales information for each database in the file with the list of databases.