Viewing 15 posts - 1,126 through 1,140 (of 3,232 total)
ducon (8/14/2009)
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...
August 14, 2009 at 10:02 am
Thanks guys, I appreciate your comments.
August 14, 2009 at 8:24 am
So go back to testing with transactions and containers and look into the blocking/locking problem cause.
August 13, 2009 at 3:52 pm
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...
August 13, 2009 at 3:39 pm
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...
August 13, 2009 at 3:27 pm
The Conditional Split is what I'm looking for.........that's one of the script components.
August 13, 2009 at 3:20 pm
Double-click on the Conditional Split task so the editor opens up. Your last screen shot shows the properties, not the setup.
August 13, 2009 at 3:15 pm
I was more interested in seeing the contents of the Transformation Editor. I'd like to see the expressions and output setups.
August 13, 2009 at 3:06 pm
OK, the error row count looks good, now what does your conditional split comonent look like?
August 13, 2009 at 2:55 pm
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...
August 13, 2009 at 2:40 pm
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...
August 13, 2009 at 12:09 pm
Yep, that'll do it. Good to hear you've got it working.
August 13, 2009 at 11:53 am
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...
August 13, 2009 at 11:52 am
Naveen,
And all of this becasue you don't know how to do this in the data flow? How long does it take the data flow to run and populate...
August 13, 2009 at 11:42 am
Viewing 15 posts - 1,126 through 1,140 (of 3,232 total)