SSIS 10 Experts Tips From Real Projects
Discover 10 Expert tips on SSIS and Microsoft BI projects in general to help you achieve success and win a lot of time and energy.
To give you some context : this video reflect somehow some senior advices on how to be sucessful in a technical role in BI, it is by the way a part of the conclusion of my full training available here:
https://www.udemy.com/course/data-int...
00:13 - 1. A Super NotePad ?
02:14 - 2. About Excel Features ... ➔ • How to pivot Excel table rows into columns?
03:18 - 3. The Pivot Tables ➔ • How to create an Excel pivot table?
04:08 - 4. Manage Your Passwords
05:24 - 5. Use some Shortcuts
06:16 - 6. The power of Scripting
08:47 - 7. SSIS Automatic Generation
09:41 - 8. SELECT * FROM and Structure Changes
10:53 - 9. Business Rules Are The Key
12:37 - 10. Test, test and test again.