Hello everyone,
I am totally exhausted as a 100MB CSV file is taking 1 hour to be get inserted into the MSSQL database when I am using pyodbc cursor.execute() method.
I searched a lot to improve the speed but still, nothing is working as expected.
I am wondering how the SSIS packages were inserting the same CSV file in 10 minutes and why the python implementation is taking an hour to do the same task.
I really appreciate any help you can provide.
Thanks,
Ankit