DSXchange

EMPTY STRING CONVERSION or NULL CREATED ON NOT NULLABLE COLUMN When performing a Left Outer Join to a secondary input where a NOT NULLABLE column on the secondary input is required for output, but the primary record does not find a match on the secondary input, a Null Representation is forced into t...

By chance I happened to come across an option called Expression Editor in the Tools - Options menu. All of the 4 check boxes were unchecked. I checked them all and was then able to access the Expression Editor Menu options from within a Transformer Derivation. Perhaps these boxes are not checked by ...

I haven't heard of this problem before. Is this limited to your client workstation - if so, then the patch probably caused the problem. ... Yes - this is specific to my client - others have no problems I haven't been able to try a reinstall yet as I telecommute from out of state to my home office a...

Upon further review - my real problem is not being able to access the "Suggest Operand Menu" to clarify - the ... icon is not enabled, but I can right click within the derivation box to show the possible options - Edit Derivation Appears - I can Manually enter a derivation or column name -...

No menu appears - it's basically a dead icon

I am not able to open the expression editor located in the Transformer Stage when attempting to define an output column derivation. This is the box with the ellipse where one can select columns or functions. I previously had a problem with not being able to open job properties in the Sequencer Job a...

Hey scorpion - Here's what I think you were looking for... The way an Empty String is defined is with two single quotes and nothing in between. ('') This is what ccatania provided. An Empty String is not the same as Null so a Null check doesn't work - the statement below is how to check for an Empty...

I experienced this error when our systems people decided to drop our database for a patch install while we were executing our batch cycle. The Permissions issue was related to the database being down. Check with the systems admin people to see if the database is available.