?
Solved

SSIS expression - Check when a file has been modified

Posted on 2008-06-20
2
Medium Priority
?
229 Views
Last Modified: 2013-11-30
Hi,

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

Thank you.
0
Comment
Question by:Endelm
2 Comments
 
LVL 13

Accepted Solution

by:
rickchild earned 2000 total points
ID: 21831606
You can use a Script Task to do this using the "File.GetLastWriteTime" method.

You can make the script task write the result to a package variable.

Something like:  File.GetLastWriteTime("C:\Test1.txt").ToString()

http://msdn.microsoft.com/en-us/library/system.io.file.getlastwritetime.aspx
0
 

Author Closing Comment

by:Endelm
ID: 31469130
Thank you! :-)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question