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.
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);}