Modern versions of the Jet Data Manager use Set Based Transformations.
Should you need to use Scalar-Valued User Defined Functions, the following demonstrates how to enable this legacy feature.
Right click on a table and select Advanced → Advanced Settings → Performance
Check the box to use Legacy Transformations.
- If Use legacy transformations is checked, the Jet Data Manager will revert to the previous SQL Code generation for transformations and create Scalar-Valued User Defined Functions.
- If Use legacy transformations is un-checked (Default) then the Jet Data Manager will generate CASE-WHEN structures in the Transformation views instead of Scalar-Valued User Defined Functions.