Skip to main content

Using a published parameter such as $(outputTableName) in a SQL writer to name a field.

Taking the parameter value to name the identity field as in $(outputTableName)UKID resolves and creates the column no problem when using a standard SQL writer. So, setting the parameter value to "MyOutputTable" results in a field name of "MyOutputTableUKID".

When attempting to do the same in a SQL FEATURE writer, the parameter will not resolve, and the column is created with the explicit string value '$(outputTableName)UKID'.

Is this behaviour expected between the two varieties of writer?

Be the first to reply!

Reply