• aaron.reese (3/24/2014)


    yup. You might need to use a script component or WMI. Here are a couple of links

    http://www.bidn.com/blogs/mikedavis/ssis/157/ssis-wmi-event-watcher-check-file-exist-creation

    http://www.bidn.com/blogs/DevinKnight/ssis/76/does-file-exist-check-in-ssis%5B/quote%5D

    Use a Script Task, not a Script Component.

    Here's a C# snippet that you should be able to adapt:

    string fldr = @"C:\Temp";

    // If directory does not exist, don't even try

    if (Directory.Exists(fldr))

    {

    Directory.Delete(fldr);

    }

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.