Viewing 15 posts - 1,231 through 1,245 (of 3,232 total)
Access absent?? Do you mean access denied? The error you are seeing usually happens when you don't have permissions to connect to the SQL instance. Are you...
August 5, 2009 at 1:50 pm
Since you are using stored procedues and the DB engine is going to be doing all of the work, the only real benefit I see to calling the SPs outside...
August 5, 2009 at 1:44 pm
Sorry for the delay in my response.
You don't need to create an event handler for the OnError event. The article that I posted a link for shows you how...
August 5, 2009 at 1:37 pm
You've already done it. The error handling is all of the stuff you've setup down stream from the OLE DB Destination. You set the error condition of your...
August 4, 2009 at 12:14 pm
Well you insertion logic is already there. It is your OLE DB Destination. If you want your data validations to happen at the database layer and redirect your...
August 4, 2009 at 11:42 am
What you need to do is set up the insert, along with the post-insert error checking logic into a single transaction so if you reach your ceiling of 50 errors,...
August 4, 2009 at 11:00 am
You can do the validations in SSIS, but we need to know what conditions cause the rows to fail. In other words, what makes the rows 'bad'?
August 3, 2009 at 4:28 pm
So, you want a failure to roll back the 5 rows?
Here's what I'd do.
Right now, you're using the error condition that the DB engine raises whenever you attempt to insert...
August 3, 2009 at 4:03 pm
Package level scope is fine. You don't need to create a new variable. By case, I mean case sensitive. If your variable is 'errorrowcount', make sure it's...
August 3, 2009 at 3:34 pm
Check the variable name in the script and make sure it matches (including case) the variable name that you created in your package.
August 3, 2009 at 3:20 pm
I tried to duplicate this will no luck. I set up a table with an identity column and ran 2 rows through my data flow. One row already...
August 3, 2009 at 3:18 pm
Sorry, my bad. In both scripts, above the Imports section at the top, add this entry: Option Strict Off.
August 3, 2009 at 2:54 pm
OK, good news, bad news. Up until now, I had not tried to use the RowCount transformation in conjunction with the Conditional Split transformation.
I went ahead and...
August 3, 2009 at 2:26 pm
Sorry for the delayed response. The RowCount transformation allows you to read in the # of rows in the data flow and place that value into a variable (of...
August 3, 2009 at 10:00 am
Yes, that is your Data Flow 1. I'm not sure I'm following you with what you're saying though. Is that now working for you?
July 30, 2009 at 3:35 pm
Viewing 15 posts - 1,231 through 1,245 (of 3,232 total)