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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin