ssis read filenames from a folder into an object type variable
1. I am extracting a zip file in a folder. I want to read all the extracted file names from that folder in a script task (string file_names = Directory.GetFiles(@"c:\MyDir\", "*.pdf");)).
2. Now, I want to write the array file_names in an SSIS object type variable, so that I can insert each file name in a table and use it for my comparison and further processing.