Post reply

Problem in loading filenames through ForEachLoop container

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

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

  • 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

  • April 30, 2013 at 5:24 am

    #1611172

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply