2

We have recently upgraded the SQL Server and SSIS projects from 2012 to 2019 version. Since this upgrade, one SSIS project is taking very huge time for completion. This SSIS project has a package which loads data from MySQL ODBC source and insert it into another MySQL ODBC destination via data flow task. The data is inserted in batches of 100K rows. Each batch previously took around 30 seconds but now it is taking 5 minutes.

I have tried out below things but nothing fixed the issue:

  1. Used different versions of MySQL ODBC drivers i.e. MySQL ODBC 5.3 Unicode Driver and MySQL ODBC 8.0 Unicode Driver
  2. Recreated the data flow task
  3. Added new ODBC connections in SSIS package and used them into data flow task
Shadow
  • 33,525
  • 10
  • 51
  • 64
Samay
  • 503
  • 6
  • 14
  • Is the slowdown on select, processing or insert? What is your ODBC configuration? e.g Drivers, versions?what MySQL versions at source or dest? Is it 32b or 64b driver? – tukan Jan 04 '23 at 20:23
  • The slowdown is in the data flow task for select from source and insertion in destination. The MySQL driver is 64bit MySQL ODBC 8.0 Unicode. – Samay Jan 09 '23 at 16:04
  • I see, do you use VMs for any part of the process? – tukan Jan 10 '23 at 09:27
  • 1
    It would also help if we could see the actual script, with the source/destination definitions. – tukan Jan 10 '23 at 09:32

0 Answers0