SSIS : Create a basic package and implement a lookup logic MP4 | Video: h264,...
What you\'ll learn
Install Visual Studio
Install SQL Server
Install SQL Server Data Tools -SSDT
Download and attach sample database
Create a new SSIS Package
Perform a lookup on data
Reference data from OLE DB source.
Perform Lookup transformation.
Setup OLE DB connection manager
Write data to cache
Requirements
Basic...