SSIS 2015 - what is the best way to create ssis task to delete only *.csv files from remote directory. I thought to use system file task with delete file content. But I cannot able to give *.csv variable. Please advise asap.
The easiest way is to use a Script Task. Your C# would look something like this (untested):
foreach (string f in Directory.EnumerateFiles(remoteDirectory,"*.csv"))
{ File.Delete(f);}
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel