Is it possible to develop something “re-usable in SSIS” ?
Yeeaaaahh !! We can develop re-usable control flow parts. Its available as part of SQL Server 2016.
I believe MSBI professionals aware of this new feature.
For more details on this: https://msdn.microsoft.com/en-in/library/mt620034.aspx
- Generic requirement in package development is that we need to log the package details like package name, start time, end time, row count details, error details. So it helps a lot for the deployment/developer team to review the package status and investigate the issues if required.
- Each and every package will have the logger. Ideally we will develop some control flow or data flow to achieve it and copying the same to all the packages.