DSXchange

Have you specified a particular temporary directory pathname in the Sort stage? With that many rows there will be a substantial delay between the final row being read from import and the first row being output, because the actual sort needs to happen in between. Are you, perhaps, merely being impati...

ODBC

Therefore the Unidata account will need to have been converted to a schema using VSG.

Try just uvodbc.config to begin with.

(Only change one thing at a time, then you'll know what the fix was.)

Welcome aboard. You specified space as the delimiter and that's what you got. What you needed was something like Oconv(Iconv(InputFieldName,"DMDY"),"D/YMD[4,2,2]") You might find this article informative. For the second question, try Oconv(Iconv(InputFieldName,"DMDY"),&...

Were there no other error messages logged, for example one that shows the values passed to the database? There are many reasons an INSERT statement might fail, from the row already existing to constraint violations and various other causes. There is not enough information in this particular message ...

The first problem is that it does not appear to be a QualityStage question.

Please post in the correct forum.

Please be careful with terminology. Blocking columns MUST acheive an exact match. Data are grouped into "sets", each with a unique Set ID, to indicate potential duplicates based on your other criteria. Increasing the disagreement weight is more likely to reduce the number of potential dupl...

Welcome aboard. Does the word "Filtered" appear in the Director's status bar? Use Ctrl-T to open the Filter dialog. And please use professional English on DSXchange. The second person possessive pronoun in English is spelled "your", not "ur". Being correct will make lif...

My guess - you have identically-named columns on both inputs and the result of the join - you have not provided separate output columns into which to map the left and right input columns.

Actually it's not what I said. What I really said is in the words - that I suspect there is a problem establishing login credentials, setting private (manual) transaction handling, or some other connection option.

First you have to GET the record count from the file. My understanding of your earlier post was that you have a row in the table of the form: FileName RecordCount MyFile 17092 and want to lookup and compare. If that is not correct, and you want to get the row count from the table, then you need one ...

That or, possibly, a Complex Flat File stage.

Provide the actual date to be used in the WHERE clause as a job parameter - do the date arithmetic in the job sequence that allocates values to the job parameter.

Make the file name a job parameter.