Keeping a Profile vertical when using in a Sweep

[Ewan_Opie]

You are on the right track with transforming coordinate systems , some minor tweaks and you should have it.
Here is a workflow for some inspiration.