Home > Articles > Data > SQL Server

  • Print
  • + Share This
From the author of

From the author of

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.

  • + Share This
  • 🔖 Save To Your Account