Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem in loading filenames through ForEachLoop container Expand / Collapse
Author
Message
Posted Tuesday, April 30, 2013 4:24 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:09 AM
Points: 75, Visits: 211
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.


--------------------------------------------------------------------------------
Post #1447947
Posted Tuesday, April 30, 2013 4:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:49 AM
Points: 48, Visits: 269
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
Post #1447954
Posted Tuesday, April 30, 2013 5:24 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:09 AM
Points: 75, Visits: 211
Thanks!! Something else was causing this issue which is now resolved.
Post #1447961
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse