Hi, I have one Requirement, where I need to pick XML files from a Folder. But that Folder contains many XML files and I have to pick the files which TimeStamp date is same as system date. How I can do this through SSIS?Thanks Shiven:)

do you mean the Created Date of files? or a file name which contains TimeStamp as string in the name? if you mean second one provide a sample of file name herehttp://www.rad.pasfu.com

Do you mean the last modified date or file creation date? http://microsoft-ssis.blogspot.com/2011/01/use-filedates-in-ssis.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

I mean Created date of file or Modified date of file.Thanks Shiven:)

OK, ik think the url will help you... 1) Use a For Each Loop File enumerator to loop through all your files. 2) Add a script task (step 14 in the link) in that loop to get the file date of each file 3) Add your data flow behind that script and use an expression on the Precedence Constraint to check if the file had a correct date. Something like: DATEDIFF("dd", @[User::FileDate], @[System::StartTime] ) >= 1 Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

OK, ik think the url will help you... 1) Use a For Each Loop File enumerator to loop through all your files. 2) Add a script task (step 14 in the link) in that loop to get the file date of each file 3) Add your data flow behind that script and use an expression on the Precedence Constraint to check if the file had a correct date. Something like: DATEDIFF("dd", @[User::FileDate], @[System::StartTime] ) >= 1 Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com