title: DataFlow task in SSIS is very slow as compared to writing the sql query in Execute SQL task
body: <p>I am new to SSIS and have a pair of questions</p>
  
  <ol>
  <li><p>I want to transfer 1,25,000 rows from one table to another in the same database. But When I use <code>Data Flow Task</code>, it is taking too much time. I tried using an <code>ADO NET Destination</code> as well as an <code>OLE DB Destination</code> but the performance was unacceptable. When I wrote the equivalent query inside an <code>Execute SQL Task</code> it provided acceptable performance. Why is such a difference in performance.</p>
  
  <p>INSERT INTO table1 select * from table2</p></li>
  <li><p>Based on the first observation, I changed my package. It is exclusively composed of <code>Execute SQL Tasks</code> either with a direct query or with a stored procedure. If I can solve my problem using only the <code>Execute SQL Task</code>, then why would one use SSIS as so many documents and articles indicate. I have seen as it's reliable, easy to maintain and comparatively fast.  </p></li>
  </ol>