Constraint in Transformer not working Please help!!
Posted: Thu Sep 17, 2009 10:21 am
I have an ODBC source through which I put the records into a transformer.
There are two outputs to the transformer. In one constraint I put String_column = "A" and in the other String_Column <> "A".
The above does not seem to work.
When I just put one output and say String_Column <> "A" all the records go in this file and if I put String_Column = "A" no records go in.
Iam using SQL Server 2005 and have already checked in the values in the db and so THERE ARE values like "A" and some others like "AA" etc.
There are two outputs to the transformer. In one constraint I put String_column = "A" and in the other String_Column <> "A".
The above does not seem to work.
When I just put one output and say String_Column <> "A" all the records go in this file and if I put String_Column = "A" no records go in.
Iam using SQL Server 2005 and have already checked in the values in the db and so THERE ARE values like "A" and some others like "AA" etc.