SSIS Project with OLE DB Source and Kingwaysoft Destination

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 :
pacakge

the OleDB source Contains the sql query,the sql query will count the total of the 10 field
OLEDBSOURCE

and finally the kingwaysoft destination mapped the fields
destination

Advertisements