I'm relatively new to SSISs.
What I currently have is a dataflow task which loads up my folder names into an ADO variable using an OLE DB Source to a record set.
I have a predefined path of where these folder names sit. e.g - "\\myServer\store\"
What I need to do is loop through my recordset and append each folder name to my path and delete that folder using File System Task? e.g. delete "\\myServer\store\Folder1FromAdoVariable", "\\myServer\store\Folder2FromAdoVariable" etc
I have had a look at a ForEach loop container but no success.