Time for action – getting orders in a range of dates by using parameters

Now you will modify your transformation so that it shows orders in a range of dates.

1. Open the transformation from the previous tutorial and save it under a new name.

2. From the Input category, add a Get System Info step.

3. Double-click it and use the step to get the command line argument 1 and command line argument 2 values. Name the fields as date_from and date_to respectively. Create a hop from the Get System Info step to the Table input step.

4. Double-click the Table input step.

5. Modify the SELECT statement as follows:

   	SELECT
   	  ORDERNUMBER
   	, ORDERDATE
   	, REQUIREDDATE
   	, SHIPPEDDATE
   	FROM ORDERS
   	WHERE STATUS = 'Shipped'
   	AND ORDERDATE BETWEEN ? AND ?

6. In the drop-down list to the right side of Insert data from step, select the incoming step.

7. Click OK.

8. With the Select values step selected, click the Preview button.

9. Click on Configure.

10. Fill the Arguments grid. To the right of the argument 01, type 2004-12-01. To the right of the...