Force delete a file using SSIS on a network location

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

Answers (1)

rvphx
rvphx

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

Related Questions