Is there a Find/Replace feature in Automation to replace the same string in multiple files? If the filename is replaced with the path\*.sql, so it will run the find and replace on all the sql files in the directory, the following error occurs.
Could not create activity of type 'Automation.Workflow1'. System.ArgumentException: Illegal characters in path.
at System.IO.Path.CheckInvalidPathChars(String path, Boolean checkAdditional)
at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters(String[] str)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath)
at System.IO.Path.GetFullPath(String path)
at Quest.Toad.Workflow.Activities.FindAndReplaceFileActivity.set_SourceFileName(String value)
at Automation.Workflow1.InitializeComponent()
at Automation.Workflow1..ctor()
Are wildcards accepted in the Find/Replace feature?