SSIS Nuggets

https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/sysssislog-transact-sql?view=sql-server-ver16  

https://www.sqlshack.com/overview-of-ssis-package-logging/  

https://www.youtube.com/watch?v=eHxdxUresDw  

https://learn.microsoft.com/en-us/troubleshoot/sql/integration-services/ssis-package-doesnt-run-when-called-job-step  

https://andyleonard.blog/  

https://blog.sqlauthority.com/2014/03/13/sql-server-ssis-data-flow-troubleshooting-part1-notes-from-the-field-019/  

  https://www.youtube.com/watch?v=6DIzd5aK96k

https://blog.devart.com/ssis-data-types-the-no-sweat-guide-with-easy-examples.html  

https://pragmaticworks.com/resources/cheat-sheet/ssis  

https://www.youtube.com/watch?v=P3s48WDNVzE  

https://www.mssqltips.com/sqlservertip/5924/copy-or-duplicate-sql-server-integration-services-ssis-environments-using-tsql/  

https://www.youtube.com/watch?v=XzBYqGHZgZE  

https://www.youtube.com/watch?v=3HcPJCBS_KY   Set Required to True so that you have to specify a value for the parameter when the package runs. Convert any connections to Project connections so they are available to any package in the project. Use the Project parameters in expressions; e.g. ConnectionString = $project::pConnectionString

https://www.wiseowl.co.uk/integration-services/videos/ssis-basics/foreach-ado/  

https://www.wiseowl.co.uk/integration-services/videos/ssis-basics/deploy-parameters/