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 hope the following bits and pieces may help someone else out in a similar situation My hand was forced really by my current web host’s (this site has a different host) inability to make sense of their overzealous anti-malware scripts. So on and…
Experienced an issue with Octopus Deploy this week refusing to pull down in-house Nuget packages. Connecting to the Octopus server and checking the error logs gave a 401 Unauthorized error. First thing I did was to hit the endpoint in a browser and it…
Powerline adaptors are pretty cheap these days. They used to be pretty expensive and the results were hit and miss but at around £30 I thought I’d give them a go. I was surprised with the results didn’t think I’d notice to much of…
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…