Reputation: 672
I am facing a problem while deleting a file on a network location using SSIS, since its a zip file, contains monthly SQL Database backup file, so I need to delete the last month file before copying current month file.
May be there is some app which were using this file, I am not sure, but I wanna get rid of this file, so that I can copy new file.
Thanks
Upvotes: 1
Views: 1491
Reputation: 2402
Use a file task and you should be able to delete pretty much anything on any location as long as you have the rights to do so.
Upvotes: 2