CODEWITHSUNDEEP
c#sql-serverssisetl
Dizzy49
Dizzy49

Reputation: 1520

SSIS Script to Delete and Create Folders

I have a loop that runs and creates a bunch of files per folder. The folders are uniquely named based on the order range, so they can change. And the folder must exist or the loop crashes.

I want to create a script that will delete all subfolders and files in each subfolder, from a root dir. ie 

Root = C:\Output\
SubFolder = C:\Output\T1-500\
SubFolder = C:\Output\T501-1010\
SubFolder = C:\Output\T1011-3076\

Then have it create folders as needed on the fly. I tried:

public void Main()
    {
        // Deletes subfolders and files in the main folder
        EmptyFolder(Dts.Variables["User::FolderName"]);

        // Creates new folder on the fly
        if (Directory.Exists(Dts.Variables["User::FolderName"].Value = 0))
            Dts.TaskResult = Directory.CreateDirectory(Dts.Variables["User::FolderName"]);
    }


    private void EmptyFolder(DirectoryInfo directoryInfo)
    {
        foreach (FileInfo file in directoryInfo.GetFiles())
        {
            file.Delete();
        }

        foreach (DirectoryInfo subfolder in directoryInfo.GetDirectories())
        {
            EmptyFolder(subfolder);
        }
    }

It doesn't seem to pick up my package level variables, and won't let me add new ones. enter image description here

I get the following when I try to use my folder variable: enter image description here

Upvotes: 2

Views: 1394

Answers (1)

Nick.Mc
Nick.Mc

Reputation: 19184

The error means you are passing in the wrong data type. Try this.

Instead of this:

EmptyFolder(Dts.Variables["User::FolderName"]);

Use this:

String folderName = (string)Dts.Variables["User::FolderName"].Value;
DirectoryInfo di = new DirectoryInfo(folderName);
EmptyFolder(di);

There is probably a way to put all of it on one line but start with that.

As mentioned in comments below, the (string) cast may not be necessary if you just use the Value property - please also try that.

You will probably also need to use your new folderName string variable in other parts of your code.

As I mentioned in the comments you can also just run a command line like this to remove a folder and all subfolders

RD <yourfolder> /S /Q

Upvotes: 4

Related Questions