C# script task in SSIS

Question

try
{
    DirectoryInfo d = new DirectoryInfo(@"\\filepath\format");
    foreach (var f in d.GetFiles("*.csv"))
    {
        File.Copy(f.FullName.ToString(), @"filepath\out\", true);
    };

    Dts.TaskResult = (int)ScriptResults.Success;
}

When i am trying the above script, i am getting the below error message

File.Copy error - C# - IOException The filename, directory name, or volume label syntax is incorrect

Answer 1

You need to copy to a file rather than a folder. The following will work:

try
{
    DirectoryInfo d = new DirectoryInfo(@"\\filepath\format");
    foreach (var f in d.GetFiles("*.csv"))
    {
        File.Copy(f.FullName.ToString(), @"filepath\out\" + Path.GetFileName(f.FullName), true);
    };

    Dts.TaskResult = (int)ScriptResults.Success;
}