Transforming data into new fields. This example will demonstrate the three primary components of a data flow: data source, data pipeline, and data destination. First, drag an OLE DB source unto the designer. Configure the data source by configuring a new connection manager and the correct database and table. For this example, I will only…

Integrating conditional logic into the data pipeline. Many projects requires the use of conditional logic to enforce logic according to business rules. In this example, I’ll illustrate such logic by diverting records between one of two Excel spreadsheets depending on whether each Employee is salaried. First, I’ll drag and configure an OLE Db Source object…