• You can do this pretty easy in SSIS. Calculate the file name, change the destination dynamically based on the calculation.