Showing posts with label flat. Show all posts
Showing posts with label flat. Show all posts

Monday, March 12, 2012

processing files with timestamp

hi guys,

i have a unique problem here.i get four different type of flat files,which i need to pick up and process parallelly,this i am doing using four different foreach containers for the four load process as i can get multiple files ( i had other issues like rollback etc for using forecah containers).

my problem is,my input file names will have format like this

yyyymmdd_salesdataforproduct_yyyymmdd_hhmmss.txt

here the first date is bussiness date and the second one is the sysytem date..if i get multiple file i have to proceess considering the second date.but by default the foreach loop is considering the first date,what can i do to ensure that only second is used to process my files.

thanks in advance

srikanth

If you want to sort the files by the second date, take a look at this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1467831&SiteID=1