I had a ssis package which loads data from a flat file at particular location to a table in SQL Server Database. There is a batch job which runs and loads the flat file to that location . Is there any way using SSIS to check the modified date on the flat file? Thanks in advance.

Yes, for sure, just use a script task. There use File.GetAttributes . Found you an example: http://jamelcato.com/how-to-check-a-file%E2%80%99s-last-modified-date-using-ssis/ Arthur My Blog

Forgot to tell you that there is a CodePlex component called File Properties Task free to use: http://filepropertiestask.codeplex.com/Arthur My Blog

you can use this code to find out CreationTime,LastAccessTime,LastWriteTime: System.IO.FileInfo finf = new System.IO.FileInfo(@"C:\SSIS\Files\testFile.txt"); DateTime creationTime= finf.CreationTime; DateTime lastAccessTime = finf.LastAccessTime; DateTime lastWriteTime= finf.LastWriteTime; http://www.rad.pasfu.com

Here is an example of filedates and 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