Friday, January 06, 2006

DTS Bug: Fail to report error message by RAISERROR

I'm so unlucky to hit a bug again~

M$ claim it was fixed since SP4.
FIX: A DTS package that uses global variables ignores an error message raised by RAISERROR

The above page said it can be solved by the security patch of SP3.
I've tried but SP3 actually didn't fix it. The patch even doesn't include update file for the DTS library dtspkg.dll.
SP4 does update the DTS runtime.

However the bug is still here after patching, if I use global variable as the SP input parameter

No comments: