I have an excel file contains around 1200 columns and 100,000 rows. I have created a SSIS package to export this dataset to a SQL Table. I am using dataflow task to export these data to SQL table, but it takes very long time more than 1 hour. The client excepts to complete this task within 1 minute.
Can someone suggest a better way to optimize this process or a better way to achieve this?
Thank you for your help!