You can use a FileName column with flat file targets.

You can add one FileName column to the flat file target definition.

You can use a FileName column with data from real-time sources.

A session fails if you use a FileName column with merge files, file lists, or FTP targets.

If you pass the same file name to targets in multiple partitions, you might get unexpected results.

When a transformation drops incoming transaction boundaries and does not generate commits, the Integration Service writes all rows into the same output file. The output file name is the initial value of the FileName port.