Hello, everyone. I am using SAS Data Integration Studio - delete transformation. This is my work flow: source table(Table A) --> extract(Temp Table B) --> delete --> destination table(Table C) First, I extract a field from the source table and suppose it will only yield one result, say id = 2. Second, I make a setting (where clause) in the delete transformation block, C.id = B.id (which is 2 from Table A) However, it always yields a result that ERROR: Expression using equals (=) has components that are of different data types. I have checked the setting of both id of both table, also the temp table on extract transformation, in SAS, they are the same. Meanwhile, I have checked the setting of both id of both table in Database, they are also the same. Could anyone suggest the problem for me? Thankyou
... View more
