Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.