Messages

1

Suggestions and Requests / Simple Math in Transformations

« on: June 19, 2010, 01:13:11 pm »

Near as I can tell the Transformation Templates don't let you perform math functions.  So the LENGTH macro doesn't do me much good.  I want to trim the last 3 characters off a name and since I can't subtract 3 from the value I get back from LENGTH there isn't really a way to do any substainially complex string manipulation.

Now if I'm just missing something and someone knows a way to make this work, please set me on the right course.

2

Automation Interface, Add-Ins and Tools / How to get Scale and Precision in Transformations

« on: June 19, 2010, 01:03:12 pm »

I am trying to write a Transformation Template to convert one data model into another (essentially changing column names, table names, etc to match a different standard).

The problem I'm experiencing is that the TRANSFORM_CURRENT macro doesn't seem to copy over the additional properties that apply to column attributes; in particular: length, scale, precision, and NotNull.

I figured out attLength, but I can't seem to find the way to grab the precision and the scale?

Any help would be greatly appreciated.