Hi,In SSIS, how can you write an expression that checks if a file got modified today?Thank you.

The only way to do this using out-of-the-box components is to use the Script Task- in the script code use the File.GetLastWriteTime method: http://msdn.microsoft.com/en-us/library/system.io.file.getlastwritetime.aspx You can then have your script task write the value you need to a package variable, and then base the expression on the value of that variable.

You can buy a custom task here: http://pragmaticworks.com/community/files/folders/ssiscomponents/entry33.aspx

Here is an example of using file dates in SSIS: 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