I need to create an ssis package to count the no of orders handled by the company and contractor. My input data has two columns related to this and if both the columns (Worklocation and station) matches, then it means its by company, else by contractor.
Can someone help me with with the "derived column" step?