Messages

1

Suggestions and Requests / Documentation for Transformations

« on: June 12, 2009, 05:53:31 am »

I'm trying to customize the DDL transformation templates, but I'm finding it hard to find very much documentation on the subject.  I've seen the section in the User Guide, but would like more.  Can someone point me in the right direction.

2

Automation Interface, Add-Ins and Tools / How do I get a return value from a template?

« on: June 20, 2009, 05:36:32 am »

This is probably something really basic, but I just can't seem to figure it out.  I have a custom template used in a DDL transformation.  I want to use it as a macro and have it 'return' a value.  

3

Automation Interface, Add-Ins and Tools / Using Counters in Names during DDL Transformation

« on: June 17, 2009, 12:18:11 am »

I am to modify the name of the FK that is created during the DDL transofrmation.  The standard for naming FK where I work is:
<<alias>>_FK# where # is a counter based on the number of FK's on the table.  So the first FK would be _FK1, the second _FK2, and so on.  I can get the general format of <<alias>>_FK but I can't figure out how to get the # part to work.  Does anyone have any ideas?  I've tried the Auto Name Coutner functionality, but it either doesn't work in transformations or I'm doing something wrong.
Thanks for any help.