Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-01-12 : 08:54:01
|
| Hi,I have source and destination in the data flow and would like to implement error handling techniques in order to log high level information like how many records inserted into the table with no errors and how many records with errors.Your suggestion is highly appreciated on this.Thanks in advance... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-12 : 10:18:37
|
| you can configure error output on destination and cause error rows to be redirected to a file or table by giving OLEDB of flat file destination.Not sure whats your logic for checking errors |
 |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-01-13 : 08:26:15
|
| when i tried to redirect the errors from OLEDB Destination to Flat file, the task OLEDB Destination is not configured properly. On placing the mouse over the task, "The error row disposition on "Input oledb destination" cannot be set to redirect...".I have created the workflow in this manner.Source file -> On success -> OLEDB Destination -> On error -> Flat file destination.Did anyone get clue on this... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-13 : 09:01:34
|
| how were you configuring error output on OLEDB destination? |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-01-15 : 01:21:41
|
| In the error output page of OLEDB Destination, Redirect row for error/truncate columns. Precedence constraint Onerror is connected to the flat file destination. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 07:59:37
|
quote:
Originally posted by carumuga
In the error output page of OLEDB Destination, Redirect row for error/truncate columns. Precedence constraint Onerror is connected to the flat file destination.
then it should work i guess |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-01-15 : 08:04:16
|
| In the connection Manager of OLEDB Destination we should change the Data Access Mode from “Table or view fast mode” to Table or View. Now its working fine. any way thanks for your input. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 08:51:38
|
quote:
Originally posted by carumuga
In the connection Manager of OLEDB Destination we should change the Data Access Mode from “Table or view fast mode” to Table or View. Now its working fine. any way thanks for your input.
ah...i missed that point...anyways happy that you spotted it out |
|
|
|
|
|
|
Error handling