Hello,

this is a question for Integration Services and I am new with it.
I have a flatfile and a table and I want to add the records from the file
into the table. Because I want only the newest records I want to use a merge
join to left outer join the new records with the tablerecords. The new
recoreds will yield NULL and with a conditional branch I want to add the
records into the table.

I don't get this to work because I still have an error in the merge join
task where the toolip says:" At least one input column must be mapped to an
output column.[[This happens when no input columns ha...". When I want to
edit the merge join I get the error:" Both inputs of the transformation must
contain at least one sorted key column each, and those columns must have
mathcing relevant attributes".

Between the flat file manager and the merge join and the data source manager
and the merge join are two sorting tasks and both sorting tasks sort on the
same column.

I do not understand why this is failing. Can it be that the datatypes
between the sources are different? The flatfile has only DT_WSTR and a
DT_DBTIMESTAMP and the table has only DT_STR and DT_DBDATE.

Any help is much appreciated.

Q