SSIS problem: File System task (delete file) does not run on remote machine
Posted on 2008-10-04
I created an SSIS package that does a number of things, the last task is to delete a file. When I run the SSIS package from within MS SQL BI is runs fine and deletes the file off the server. However, when I run the package using DTexecUI, on the same machine, the delete task does not execute. The file never gets deleted on the remote server. Just so you know, I do not have SQl database or integration services installed on this machine, I just have the Business Intelligence Studio installed. Any ideas?