Dear All,

I am facing a problem that how to log descriptive error in database or flat
file when lookup failure occurs.

Regards,
Stephen

Hello Stephen,

Are you using SSIS? Although by default the Lookup transform will fail when
it fails to get a match, you can change this behaviour by chaging the error
output to either ignore the error or redirect. if you redirect then you
know that the rows that are flowing down the error output are not matched
rows.





Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan,
I had the same question and I'm using DTS, not SSIS.
My question is how do I capture the database error if the DTSLookkup
statement fails.

Thanks in advance for your help.

Kim.

Allan Mitchell wrote:
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200604/1

Hi Stephen,
Do you have a resolution for this?

Thanks,
Kimberly.

Stephen wrote:
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200604/1