Posts

SSIS – How to use Execute SQL Task to assign value to a variable?

SSIS Variable and Parameter Analysis

Using FOREACH containers to loop over files

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

sysssislog (Transact-SQL)

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

Overview of SSIS Package Logging

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

SSIS Log Providers Demystified

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