In this project we will create a project SSIS that will update a 10 field of entity, so i added a Data flow that contains an OleDB SOURCE that contains a sql query and a KingwaySoft destination that will update the 10 fields.
the DataFlow of the package :
the OleDB source Contains the sql query,the sql query will count the total of the 10 field