based on your experience I might discuss some real examples of implementation on:
-Script Task: to implement a custom control flow task
-Script Component: to implement a custom data flow source, transformation, or destination
I suggest you take a look at the following link that describes how to query AD with SSIS:
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.