I have three CSV files, that each one contain 462 rows and 56 columns. I created the unpivot task and this is very slow for 9 hours and not finished. The last status in progress is the count of rows of the first file.
Any suggestion, alternative?
I have three CSV files, that each one contain 462 rows and 56 columns. I created the unpivot task and this is very slow for 9 hours and not finished. The last status in progress is the count of rows of the first file.
Any suggestion, alternative?
The first thing would do is to get a basic idea of where the problem is. I would test a simple package that reads one file and shows the output in a data viewer. How long does that take?
You could see if using the script component works for you. Check out https://www.sqlmovers.com/ssis-flexible-unpivot/.
Hi @EL-8503 ,
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.
5 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh