In this section, you will create a transformation very similar to the one you created in the previous section. In this case, however, you will interact with Spoon by telling it one-by-one which source files you want to send to the destination file:
Create a new transformation.
From the Input category of steps, drag to the work area a Get System Info step.
Double-click the step and add a new line to the grid. Under
Name
typefilename
. AsType
select command line argument 1, as shown in the following screenshot:Click on OK.
Add a Calculator step and create a hop from the previous step toward this step.
Double-click on the Calculator step and fill in the grid as shown in the following screenshot:
Select the Calculator step, and press F10 to run a preview. In the Transformation debug dialog, click on Configure.
Fill in the Arguments grid by typing the name of one of your input files under the
Value
column....