Viewing 15 posts - 1,201 through 1,215 (of 3,232 total)
Your master proc will catch the error if you raise an error in the child proc. You'll just need your master's catch block to capture and raise the actual...
August 7, 2009 at 10:56 am
From your data flow screen shot, it does not appear that any of the data flow is being executed. Your control flow shows the data flow as failing. ...
August 7, 2009 at 10:43 am
This data flow is not being executed, what's happening in your Control Flow? Can you give another screen shot of your control flow for the 'Required' option run?
August 7, 2009 at 10:30 am
I walked through my example package that I've set up to play with this and it works as expected for me. When the data flow is set to Required...
August 7, 2009 at 10:11 am
OK, just so we don't have to go back and forth on this 10 more times, can you get a screen shot of the package execution with the data viewer...
August 7, 2009 at 9:42 am
A data viewer is not a transformation. If you double-click on the green arrow prior to the Conditional Split, it will open up the Data Flow Path Editor. ...
August 6, 2009 at 11:22 am
Post your table DDL along with a few rows of sample data (readily consumable as described here: http://www.sqlservercentral.com/articles/Best+Practices/61537/.
August 6, 2009 at 10:35 am
So, you tested it with your failure condition set to fail (default output) when there are > 50 errors. That worked as expected.
Then, you changed the condition...
August 6, 2009 at 10:33 am
Of course not!
I suppose after re-reading your original post, you did say that you're data is comming from a SQL Server DB. You can write a stored...
August 6, 2009 at 9:54 am
But I thought you wanted to fail with errors >= 50 not <= 50? Can you post a new screen shot of your current data flow?
August 6, 2009 at 9:45 am
Did you write the SSIS package? The package could be ignoring the error for a number of reasons. It could be set up to execute the next task...
August 6, 2009 at 9:26 am
This should help: http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx
August 6, 2009 at 9:23 am
So you are saying that the rollback is happening correctly for your error condition when there are more than 50 errors?
Are you also saying that it is rolling back when...
August 6, 2009 at 9:16 am
Viewing 15 posts - 1,201 through 1,215 (of 3,232 total)