• Great article and nice set of Script example code.

    I have a question about it though.

    We do a lot of similar ETL updates to row records during import by using SSIS DATA FLOW task and the "Script Transformation" component in the Data Flow task. This runs fast in debug mode and very fast on the server.

    Is there a reason you do it this way instead of a Script Transformation in a Data Flow task object?