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.
--------------------------------------------------------------------------------