I have an SSIS 2012 package, with a ForEach loop that goes through a folder.
Question: Does anyone know how to pull of 'How to determine the file with the most recent 'Date Modified'? My source folder will contain a full-load file generated each day, and my task is to use the most recent file, and delete the rest. Thanks in advance.
It sounds like this article may be of use to you.
SSIS -How To Get Most Recent File from Directory And Load To a Table [ SSIS Script Task ]
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…