I found some similar cases on internet:
... but no real conclusion on being a BULK INSERT issue or a misconfiguration.
However I just tested a workaround in the template, which works for me :
- Open your "Load Rdbms to Mssql (with BULK)" template
- Double click the "Load" step
- Add a parameter, Name: "rowSepOnLastRow", Type: "Boolean", Value: "True".
- The ".dat" file will be generated with a last "end-of-line" character, which avoids the issue.
- Save the template and test the mapping.
Does it work for you ? If yes I will submit the modification to our dev team so that it's included in the official template version...