SQL Server Integration Services package to delete files from a Network or Local path based on date

Posted on SQL Server Central See other posts from SQL Server Central
Published on Wed, 26 Jun 2013 06:00:00 UT Indexed on 2013/06/26 10:25 UTC
Read the original article Hit count: 122

Filed under:

We have a requirement to delete a group of files that are older than the specified number of days from the company file share. Due to the complex folder hierarchy and delicate nature of the data stored in these files, this task has to be originated from SQL Server. However, due to company security policy, and based on SQL Server security best practices, we blocked access to OLE Automation stored procedures, CLR features, and xp_cmdshell. Is there any way to accomplish this task without using these features?

© SQL Server Central or respective owner