i am doing some ETL works. The work consists to extract some information from excel , transform , and load into MSSQL 2008. I did it , but the issue is about the speed at which the data get inserted into the DB. for around 85.0000 record it takes 20 mins
to execute the task. so now i am looking for a way to improve the performance. May be less than 10 mins will be ok for the 85000 records. how can i achieve that ?
djamajo
Member
115 Points
104 Posts
Improve performance of ETL
Nov 06, 2012 10:57 AM|LINK
Hi,
i am doing some ETL works. The work consists to extract some information from excel , transform , and load into MSSQL 2008. I did it , but the issue is about the speed at which the data get inserted into the DB. for around 85.0000 record it takes 20 mins to execute the task. so now i am looking for a way to improve the performance. May be less than 10 mins will be ok for the 85000 records. how can i achieve that ?
Please any help