Data from resultset to destination server table

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  July 20, 2011 at 1:29 pm

  #241852

  Hi !

  I have a execute SQL Task and i am running one query and it gets data of 200-500 rows of data and i am assigning to a variable for the ResultSet..and i and building my package by taking the reference of "http://www.sqlservercentral.com/Forums/Attachment2144.aspx" . I was using for each loop for the Resultset rows of data and inserting it into my destination table.The package is working fine but its taking more time to insert data in to the destination by picking up row by row from the resultset.so is there any way that i can transfer the data directly to a destination table from Result set

  Thanks in advance ...

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  July 27, 2011 at 1:37 am

  #1358990

  Why don't you execute the SQL statement directly in an OLE DB source instead of an Execute SQL Task?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP