Combine the Foreach Loop and the Execute SQL Task?

• Smash125

  Hall of Fame

  Points: 3562

  More actions

  April 2, 2012 at 8:19 am

  #258441

  Three flat files

  test1.txt

  test2.txt

  test3.txt

  located in folder c:\Folder

  Column names in these folder ContactId, FirstName, MiddleName, LastName.

  i want to insert data from these files in to table called "ContactParameter" which is having same columns. What

  What should be the approach if you want to Combine the Foreach Loop and the Execute SQL Task?

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 2, 2012 at 12:32 pm

  #1467807

  Why the Execute SQL Task? That will not help you efficiently load files from SSIS. Did you mean Data Flow Task?

  Looping Through and Loading Files with SSIS

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• sqlserver8650

  Ten Centuries

  Points: 1121

  More actions

  April 2, 2012 at 2:32 pm

  #1467901

  Hi

  Use the datflow task inside the foreach loop container

  Configure the foreachloop enumerator to your folder

  Thanks,

  Mark