Scenario:How to generate file name dynamically  with name of sys date ?

 

Solution:

  1. Drag your target file to target designer and add a column as show on the picture. It’s not a normal column .click on the ‘add file name to the table’ property. (I have given a red mark there)
  2. Then drag your source to mapping area and connect it to an expression transformation.
  3. In expression transformation add a new port as string data type and make it output port.
  4. In that output port write the condition like describe as bellow and then map it in to filename port of target. Also send other ports to target. Finally run the session. You will find two file one with sys date and other one is ‘.out’ file which one you can delete.