Passing Matched and Unmatched Records to the Same Destination using the Lookup Transformation

How to configure a package that pass matched and unmatched records to the same destination. #SSIS tutorials for Beginners by #COZYROC

Timeline:
0:00 Introduction
0:30 Source data
1:36 Data flow task
2:15 Flat file Source setup
3:32 Lookup configuration
4:32 Mapping
5:54 OLE DB destination
6:44 Mapping columns

See also:
⭐ DB Destination component
https://www.cozyroc.com/ssis/database...
Efficient, high volume create, update, upsert and delete of database records.
Support regular and bulk operations.
Support SQL Server, Oracle, PostgreSQL, DB2, Informix, MySQL, SAP ASE, Teradata databases.
Support 32bit and 64bit database drivers (ADO.NET, OLE DB, ODBC).
Support redirection of incorrect rows to error output (except in bulk mode)

⭐ Lookup Plus Component
https://www.cozyroc.com/ssis/lookup
Support multiple lookup definitions in one place.
Support OLEDB, ADO, ADO.NET or package variable as a source.
Support Distributed Cache 1.5 SR-1.
Support definition for handling NULL and No Match situations.
Intuitive user interface.

🔔 COZYROC SSIS+ is a comprehensive suite of 240+ components for developing ETL solutions with Microsoft SQL Server Integration Services https://cozyroc.com/products

✔️ Free for test and development within Visual Studio
✔️ Easy-to-use, coding-free library of tasks, components and reusable scripts can significantly cut your development time and also improve the execution speed of your SSIS packages.

#XML #ETL #COZYROC #SQLServer #SSIS #ssistutorial