DSXchange

Posted: **Wed Sep 26, 2012 8:04 am**

Hi,

I am trying to merge to sequential files

job design: merge stage, transformer, sequential file.

I am getting
merge_test..Merge_1: Error opening second input file
fatal error: merge_test..Merge_1: Link property retrieval error

Please any help on this
Thanks

Posted: **Wed Sep 26, 2012 8:12 am**

It doesn't like what you specified as the second filename. Make sure it is spelled (and cased) properly and permissions are correct.

Posted: **Wed Sep 26, 2012 12:15 pm**

I checked, I defined it.
but still this is Fatal error:

merge_test..Merge_1: first file column 'Name' must be present in output column list.

Thanks

Posted: **Wed Sep 26, 2012 12:34 pm**

What is the cirteria to merge the files.
2 file with same meta data, IS THIS RIGHT?

Posted: **Wed Sep 26, 2012 3:10 pm**

Think for a moment what the Merge stage is doing. This will provide some guidance about which columns need to be identically named and which ones do not.