Besides the MLK identity column, is there any way to uniquely identify rows? What is RECID?

ducon (8/14/2009)

---

Hi John,

One last thing though if I may... How is message reception/delivery guaranteed with the service broker? Can you for example set a retry count etc. and have a...

Thanks guys, I appreciate your comments.

No problem, glad to help.

So go back to testing with transactions and containers and look into the blocking/locking problem cause.

This has nothing to do with the transaction setting so let's hold off on changing them for the test. This is the conditional split that's the problem. Let's...

You've got the expression set to check the value of the ErroRowCount variable. You need the expression to check the value of the Error Row Count column. Remove...

The Conditional Split is what I'm looking for.........that's one of the script components.

Double-click on the Conditional Split task so the editor opens up. Your last screen shot shows the properties, not the setup.

I was more interested in seeing the contents of the Transformation Editor. I'd like to see the expressions and output setups.

OK, the error row count looks good, now what does your conditional split comonent look like?

What you are seeing here is a problem with the conditional split. Those rows should not be getting routed to the flat file. What does the RowCount column...

You don't have to 'assign' the variable to any of the container properties. All you need to do is create the variable and add a script task with the...

Yep, that'll do it. Good to hear you've got it working.

Wow, well obviously something has changed. That's the funny thing with programming anything, whether it be in SSIS, T-SQL, or a .net language, the programs will do exactly what...