SQL
for opening files https://docs.google.com/forms/d/e/1FAIpQLSeJ6CvorYIYW4ZipSfLA5z0-Mim8smq-O9yxjW1c9N9_kFPbQ/viewform?usp=dialog
SSIS:
- https://youtu.be/X0nBOQJ5Jxo
- dataflow https://youtu.be/sY4-5bWQ2r4
- variables and constraints https://youtu.be/SV_SQzfDDsI
- https://youtu.be/-km_7y6vano constraints
- https://youtu.be/jwSakjneGuo DerivedTransform
- https://youtu.be/EWIow6r3PRU conditionalsplit
- https://youtu.be/21rOfwXRkhs handlingerrors and derived transforms
- exceldataloadssis https://youtu.be/jvwueDgWBwo
- https://youtu.be/-t5h8HXJAAY transforms