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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-04-02 : 07:48:35
|
| Hi i have a look up from one table to another now i know that some data is set to null in one table and this is the row am doing the lookup on. I'd like the package to run as normal and still catch these failing rows. Is this possible to do ?.I was trying to set the Configure Error output but i can't get my failing rows to be set to the text file.. the package runs ok But am getting the same problem again in another lookup as am using the same data to do a lookup again and its causing me the same problem. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-02 : 09:59:37
|
| You need to give redirect row option in Configure error output and link a text file destination to error text file from lookup task for failure constraint. On running package,the failed rows will get populated to error text file. |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-04-02 : 10:41:25
|
| Hey i got it to work thanks very much. I did not have one of the setting set to redirect row so thats why i was not getting my data out to the text file.thanks again. |
|
|
|
|
|
|
Lookup to catch failing rows