tMSSqlSCD does not commit

[fjblau]

I have a job that is running a tMSSQLSCD component.

I can see the 11000 or so rows running into it, but nothing shows up in the query editor. I have tried setting the AutoCommit in the component, and I have tried turning that off and doing a commit with the tMSSqlCommit component.

I have tried recreating the table, recreating the job and just about anything else.

Is this a bug, or am I missing something?

[jlolling]

Actually I would NEVER recommend to commit inside this component, even it would be possible. This can lead to inconsistent time-slices. The best thing you can do is switch off the auto-commit on the connection and use a tDBCommit component linked by the OnSubjobOk of the whole sub job!

I also recommend to have a tLogCatcher component and take care only tDie and Java Exceptions will be catched and connect its output flow directly to a tDBRollback component. The tLogCatcher should not be triggered, simply keep it alone on a location on the upper part of the job.

[fjblau]

I tried that too and it still didn't load any data into the target.

I have re-written it as a SQL Merge in a tRow component since the SCD clearly isn't working as it should.