Ale, music and enjoying life.
When running SSIS components through SQL Server Agent jobs sometimes an error may appear and when viewing the job history you’ll see the helpful “To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report”. If…
I was tasked with making changes to a fairly old SSIS component the other day which wouldn’t normally pose a problem but headaches and wasted time was heading my way. There’s a particularly nasty property within SSIS which when set to TRUE can simply…
Spent a few minutes trying to assign null to a derived variable as part of a script task transform. In my mind Row.CreatedDate = null would do it right? After, making the changes and running the data through again I could see that this…
Hit an issue recently where a csv file was being transformed through an SSIS package but persisting to the database as zero value integers for all null value columns. Spent time examining table constraints through trying to establish why this was occurring. It’s not the…