Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-10-12 : 01:02:22
|
| Hi All,I am processing the file in T-SQL which is stored in the folder based on the file name.So now i wish to process the file i mean i need to put a condition where i can check the filemodified attribute in the folder.If the filemodified is today i wish to process the file if not i will make alert to app team to upload latest file.Any suggestions are welcome.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-12 : 01:34:47
|
| you can make use of file system object inside script task and retrieve ithttp://jamelcato.com/how-to-check-a-file%E2%80%99s-last-modified-date-using-ssis/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Datemodfied attribute while fetching the file