Hi @E L ,
Please divide the CSV files into different small files.
Then use Unpivot Transformation in SSIS Data Flow Task.
Please refer to Integration Services Performance Best Practices – Data Flow Optimization.
Best regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.