Update for DTS_E_INDUCEDTRANSFORMFAILUREONERROR issue in SSIS.
In reference to the KB article "http://support.microsoft.com/kb/969845",
I have imlemented Method 1 as suggested by Microsoft, and as of today,
March 29, 2010 this error has not been encountered again. In my previous
post, i had mentioned the reading failure for pageviews and it turned
out to be nothing related to the DTS_E_INDUCEDTRANSFORMFAILUREONERROR
issue.

Looking back on the logs, we had a .NET service pack install(totally by
accident, disable those auto updates), on the same week this error
started appearing.

As a result of using Method 1, all issues reading from MySQL and this
transformation error have disappeared.
Hope this helps SSIS fans.

Rick Hall

*** Sent via Developersdex http://www.developersdex.com ***