The Jet Data Manager has changed the way it handles transformations. The code generator will now use use Set Based Transformations instead of Scalar-Valued User Defined Functions. This should have a huge increase in performance.
As changing how we generate transformations in SQL is a major change, we have decided to include a way to turn this new functionality off if it - against our best intentions and testing should generate wrong code in some scenarios. The follow demonstrates how to enable Scalar-Valued User Defined Functions.
1. Right click on a table and select Advanced → Advanced Settings .
2. Check the box to enable UDF Transformations.
- If Use UDF 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 UDF 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.