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 |
|
Rupa
Posting Yak Master
123 Posts |
 Posted - 2007-06-27 : 09:58:57
|
| Hey allI am importing data from a CSV file into an SQL table. All the successful rows get inserted into that table and any error rows get redirected to the derived column data flow transformation tool which then puts the errors into an .xls file. All this works fine but the error file doesn't have the error description and row identifier. How do I insert the row identifier (say PK is PersonNo and PersonNo 58's details are incorrect) and the error description? I tried the errorcolumn but that gave a random number 96 when the error was in record 58. I hope I'm making sense. Any help will be highly appreciated..ThanksRupa |
|
|
|
|
|
How do I identify column name when error occurs?