Alert if folder not updated within given time eg 90minutes SSIS 2008
Hi, I need to place a watch on a shared folder to see that folder has had files dumped into within 90 minutes.
Can someone please guide on how to (SSIS 2008 R2)
Obtain the latest time of a file in a folder called
\\abcserver\123\testfolder\If greater than (90) minutes ago, send email alert
Would run this package as a service every 10 minutes
Alternatively is there an easier way?, thanks
December 6th, 2012 5:16am
There are no inherent SSIS task available, nevetheless you may use powershell to watch the designated folder and send emails
See this:
http://gallery.technet.microsoft.com/scriptcenter/Powershell-FileSystemWatche-dfd7084bPlease vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar |
My Blog
Free Windows Admin Tool Kit Click here and download it now
December 6th, 2012 5:39am
You can use the DirectoryInfo and FileInfo classes in .NET (in a script task) to retrieve directory and file properties.
For example, in DirectoryInfo you have the FileSystemInfo.LastWriteTime Property to find out the last time a directory was written to.
Check the difference between the retrieved value and the current datetime and if it's greater than 90 minutes, set a variable to true.
After the script task, you put your email task and you connect them with a precedence constraint. On this precedence constraint, you put an expression like this:
@Over90Min == TRUEMCSA SQL Server 2012 - Please mark posts as answered where appropriate.
December 6th, 2012 5:43am
You could use a
WMI task with a 90 minute timeout...Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com |
Twitter
Free Windows Admin Tool Kit Click here and download it now
December 6th, 2012 6:22am
You can use the DirectoryInfo and FileInfo classes in .NET (in a script task) to retrieve directory and file properties.
For example, in DirectoryInfo you have the FileSystemInfo.LastWriteTime Property to find out the last time a directory was written to.
Check the difference between the retrieved value and the current datetime and if it's greater than 90 minutes, set a variable to true.
After the script task, you put your email task and you connect them with a precedence constraint. On this precedence constraint, you put an expression like this:
@Over90Min == TRUEMCSA SQL Server 2012 - Please mark posts as answered where appropriate.
December 6th, 2012 1:36pm
You could use a
WMI task with a 90 minute timeout...Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com |
Twitter
Free Windows Admin Tool Kit Click here and download it now
December 6th, 2012 2:16pm
Thank you both for the guidance, been away, so will test and advise of outcome this week.
December 9th, 2012 5:18pm
Thank you both for the guidance and support. All replies were useful.
Free Windows Admin Tool Kit Click here and download it now
December 10th, 2012 1:15am