When I use the <right click> Export | Export Wizard from the data grid results, I'm unable to check 'Save template'. The checkbox is grayed out. How do I create a template?
Not being able to save an export template when invoked from the data grid is intentional. When the export wizard is invoked, all of the contents from the data grid are sent to the wizard for export, and there would be no way to save that information in the export template, which is why saving is disabled.
Use Tools | Export | Export Wizard to create a template
Use the 'Build Template' button directly from the 'Export Wizard' activity in Automation.