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: 141
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