DSXchange

According to Ascential, this is a bug in v6.0.1 which is fixed in v6.0.2 and all later releases. Can you guess which version I am working with? I have found a workaround though. I've replaced on the of the sequential files with a hash file and am using a lookup to combine the 2 sets of data. Not as ...

Saravanan There is one column that has null values and it is set to nullable everywhere it appears. Roy This is a job that was built by a contractor who was brought in to work on a number of things and has never been tested up to now, so as far as I know, it has never worked. I tried rebuiding the m...

Saravanan, Thanks for the quick response!

The join is a "Pure Inner Join".
I have checked the files and there are no nulls in the key column in either file.

Hello, I'm getting a problem with a job that starts with a merge stage. The Merge is on 2 text files that are created by other jobs run earlier in a sequence. The 2 text files exist and contain the appropriate data. The error appears in the log as follows: Event: Starting Job PIniMedStage4.1. (...) ...

I am also getting this error. I have checked the permissions on the directories and files. I can view the data in the 2 files from the job that creates them and it looks like it should. The key columns for the merge are not null. Any help or advice would be much appreciated, I've run out of ideas! T...