
March 20th, 2003, 07:23 AM
|
|
Junior Member
|
|
Join Date: Mar 2003
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
How to know the exact row and column that hit error in DTS?
I am working on DTS Package. I am importing a lot of data (many rows) to many columns in a table. When any of the row(s) encounter, the row will be skipped and continue with the other rows.
The skipped rows will be recorded in a table, lets said 'errorTbl' with the row number and most important the column(s) that hit the error.
I try to not use many counters that always make the package run slow. The DTS should have its own method on how to get the row and column without user defined counter.
Can anyone help with this problem? I search through MSDN but cannot find one that suit my need.
Thanks in advance
|