Ssis-652 -

Dts.TaskResult = (int)ScriptResults.Success;

There are several reasons why the SSIS-652 error code may occur: SSIS-652

The SSIS-652 error code typically occurs when there is an issue with the data type conversion or mapping in an SSIS package. Specifically, this error code indicates that "the data type of a column in the data source is not compatible with the data type of the same column in the data destination." Dts.TaskResult = (int)ScriptResults.Success

: Provide an option to preview data in real-time as it flows through the data transformation pipeline. This feature will help users to validate and debug their data transformations more efficiently. SSIS-652