i understood that you fell sick of me...that's why you mentioned like "it has pictures"...sorry buddy...i have been telling you...

Koen Verbeeck (12/13/2011)

---

Create a table, flat file, whatever you want.

Put error handling on the component that you want to monitor. Create a destination for your table, flat file whatever. Draw...

Koen Verbeeck (12/13/2011)

---

Euh. Problem solved?

That's the point of custom logging. If you handle the...

Koen Verbeeck (12/13/2011)

---

What do...

i am able to get the error columns as well as tables..but not able to get the exact error records...is this possible to get the records..?

Koen Verbeeck (12/12/2011)

---

Charmer (12/12/2011)

---

Koen Verbeeck (12/12/2011)

---

Charmer (12/12/2011)

---

Koen Verbeeck (12/12/2011)

---

You can use the standard built-in logging for that.

The only thing you need to do is change the connection manager for the...

Koen Verbeeck (12/12/2011)

---

Charmer (12/12/2011)

---

Koen Verbeeck (12/12/2011)

---

You can use the standard built-in logging for that.

The only thing you need to do is change the connection manager for the log provider each...

Koen Verbeeck (12/12/2011)

---

You can use the standard built-in logging for that.

The only thing you need to do is change the connection manager for the log provider each time you run...

i thought this was the exact area where...

hxkresl (12/9/2011)

---

Well, that there was a smokescreen and it is now being handled (ahem, null). Actually, I am puzzled why I have to handle the nulls between staging and...

hxkresl (12/8/2011)

---

Hi Charmer,

Yes, the error is:

[OLE DB Destination [119]] Error: There was an error with input column "Copy of POAmountLC" (219) on input "OLE DB Destination Input" (132). The column...

i found some sample databases...it is very useful to me....Thank you...

hxkresl (12/7/2011)

---

Here's whats exactly what is coming in and going out at each data flow task.

OLE DB Source

external column numeric [DT_NUMERIC] 15, 2

output column numeric [DT_NUMERIC] 18,0

Data Conversion

input column...

hxkresl (12/7/2011)

---

Ah yes, Charmer. It was simple and you are correct.

CHA CHA CHA. It WAS a constraint. Those darn Nulls get me every time.

I hope I have finally...

hxkresl (12/7/2011)

---

But Guess What, Charmer? I have another problem and I bet you can help me 🙂

Dataflow tasks are as follows:

OLE DB source -> OLE DB destination

The source is...