Popular White Paper On This Topic

version 8.1.1 Targets Generate flat file targets by transaction. You can generate a separate flat file target each time the Integration Service starts a new transaction. You can dynamically name each file. To generate a separate output file for each transaction, you add a FileName port to the flat file target definition. When you connect the FileName port in the mapping, the Integration Service writes a target file at each commit. The Integration Service uses the FileName port value to name the output file. You can generate output files from source-based or user-defined commits. version 8.5 Get file names for sessions that use a file list. For sessions that read source data from a file list, you can configure the associated mappings to return the name of the file from which a row has been read. Regards sukumar