A directory structure exists with a main folder e.g. c:\test and sub-folders for each object type that was exported in a 'Generate Schema Script' action. e.g. C:\Test\Tables, C:\Test\Procedures
In 'Automation Designer', prior to generating the Schema Script, a 'Folder Iteration' action is placed to delete all files with .sql in the sub-folders (using the RECURSE option). Although the app appears to run successfully, all files are not being deleted.
RESOLUTION 1:
In the Generate Schema Script action | Source and Output tab - Select the Use SQL extension for all files option
RESOLUTION 2:
In the Folder Iterator option of the Automation Designer App, change the file types to select all the files.
