SSIS Project | ssis real time complex project | ssis interview questions and answers | part 6
Channel: SS UNITECH
Date: 2021-10-04

#ssis #ssisinterviewquestionsandanswer #ssunitech
ssis interview questions for experienced | SSIS Project | ssis real time interview questions | ssis interview questions and answers

Before watching this video, must watch below videos:
Incremental Load: - https://youtu.be/PayvxG2om3s

Lookup: - https://youtu.be/D-BooJ4zCE8

Lookup Cache Mode: - https://youtu.be/a3JE4N4GQ7w

Cache: - https://youtu.be/eQxdJ8PcFC8

ForEach File Enum: - https://youtu.be/Eqglee18K_s

Sequence Container: - https://youtu.be/fHaGcmszrQM

OLEDB Command: - https://youtu.be/_VpVeteIrRc

Send Mail: - https://youtu.be/wbhlCkmeAwc

SQL Script:-
Update CustDetail 
Set CustName=?,Address=?,City=?,State=?,Country=?
Where CustId=?

Delete 
From CustDetail
Where CustName=?

Update [Emp_destination]
Set EmpName=?,Salary=?,DeptId=?
Where EmpId=?

Update [Emp_destination]
Set isdeleted=1
Where EmpId=?

Find Us On YouTube- "Subscribe Channel to watch Database related videos"          https://www.youtube.com/channel/UCZA_5vGtSpZu86VBDdSnSag

For Quiz-
https://www.youtube.com/watch?v=IaDXFyZSo7Y&list=PLNRxk1s77zfitFbrlRICVDgVodMr25mYl
 
Find Us On FaceBook-
https://www.facebook.com/SS-Unitech-187705388674384/