Like this article? We recommend
Data-Driven Queries
Data-driven queries must process each source row separately. On larger files, the additional processing can add up quickly.
Although it may be more complex, where possible, consider using a BCP or Bulk Insert Task to load the data followed by an SQL script to process the data as a set.
In addition to making the process more efficient, each task will be simpler to develop and debug.