Error on left join to an empty data set

Hello,

If I try to join the results of two data sets via a left join in a joiner as seen below and one data set is empty I get an error and the transformation fails.
In the image below which displays my test scenario, I read from two text files, one with a few records and one that only has headers (empty data set). The validators and transformers are all passthrough with nothing special happening. The reader "Test1" has data but the reader "Test2" is empty.


Here is the joiner:



This is the error:


Note that this error also occurs if the empty data set is a transact SQL table. I need to join on this potentially empty data set with a left join to get a distinct list of keys from both a current file being processed in ETL and a SQL table which will not always contain data.

Thanks in advance. In the mean time I can check if the data set contains values before running the transform.

Please let me know if you need further information.

-Phillip
Advanced ETL Enterprise 5.8.2.20
Windows 7 SP1 Ver 6.1.7601
MS SQL Server 2008 R2

Phillip

The problem you reported was corrected in the latest release