Here is a list of regular expressions that work for me in Visual Studio when locating/replacing text in SQL.
- generate scripts tasks for data will turn dates in to HEX. For example, it will turn a row_created_data column into CAST(0x000063DF01035C97 AS DateTime). I want to change those dates to GETDATE(): search for 'CAST\(0x:h AS DateTime\)' (:h searches for hex values)