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.
Constraint in Transformer not working Please help!!
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Fri Jul 17, 2009 11:42 am
-
- Participant
- Posts: 9
- Joined: Fri Jul 17, 2009 11:42 am
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: Constraint in Transformer not working Please help!!
Hi harsh_cs31, :D
Is NLS installed in your server?
When you import the metadata, what utilily do you used? odbc table definitions?
If your field are Char you must apply Trim before the compare, in Varchar doesnt' needed.
Please check the column Extend in the field definitions and blank the value,
because when the Unicode value are assigned the string comparations dont work correctly.
Send us the results.
Is NLS installed in your server?
When you import the metadata, what utilily do you used? odbc table definitions?
If your field are Char you must apply Trim before the compare, in Varchar doesnt' needed.
Please check the column Extend in the field definitions and blank the value,
because when the Unicode value are assigned the string comparations dont work correctly.
Send us the results.
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Participant
- Posts: 9
- Joined: Fri Jul 17, 2009 11:42 am