We used the Partition By transformation to split a dataset into multiple files. Unfortunately, it created files with names that included the original destination filename, for example:
order_1234.csv, where 1234 is the value of the Partition By column. What we really need is just
1234.csv. Is there any way to do this?
Ignore Original File Name property under Mapping/Additional Transformations/Partition.