Problem in loading filenames through ForEachLoop container

• Sachin Vaidya

  Ten Centuries

  Points: 1273

  More actions

  April 30, 2013 at 4:24 am

  #293227

  Hi,

  I am using SSIS 2005 ForEachLoop container to pick the files from a location. My files have mainly 3 types of names.

  1.XYZ_ra20130406289018wb_59815.NOR

  2.XYZ_a201304300926hbv0_58099.NOR

  3.XYZ_ca20130406289012vq_8.NOR

  I have configured the ForEachLoop accordingly by providing appropriate variable name as into 'directory' property (in collection) and set the variable mapping to a variable which will store the filename for each file.

  I am storing the file names in a table. The problem is, I could store only single type of filenames (starting with XYZ_a) and not the other types which are starting with XYZ_ra and XYZ_ca. Any inputs on where I am making any mistake will be very helpful.

  Regards.

  --------------------------------------------------------------------------------

• sumit.joshij

  Ten Centuries

  Points: 1040

  More actions

  April 30, 2013 at 4:58 am

  #1611167

  Please check this blog:

  http://msbi2012.blogspot.com/2013/04/for-each-loop-with-file-system-task.html

  Thanks

  Sumit Joshi (sumit.joshij@gmail.com)

  msbi2012.blogspot.com

• Sachin Vaidya

  Ten Centuries

  Points: 1273

  More actions

  April 30, 2013 at 5:24 am

  #1611172

  Thanks!! Something else was causing this issue which is now resolved.