I am creating a package that will delete all files from a directory, and then copy new files into that same directory.
I am having an issue with the delete task. I have tried both a Script Task and a File System Task. Both are throwing an Access Denied error. I have given the Service Account that SSIS uses, Full Permissions to that directory. I can copy file into the directory fine, I just cannot Delete anything from there.
Does anyone have an idea of what I may check or look into? Of does anyone have a better way of doing this?
For the time being, I have set up a SQL job using xp_cmdshell (I know, I really hated to turn that feature on to perform a delete. That is usually turned off always!!)that does go out and and delete all the file before the copy. That works fine. What am I missing when using the SSIS package?
Thank you in advance