Category: Comps

SSIS Troubleshooting – Reporting

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 you attempt this you may get an “Out Of Memory” exception due to the sheer amount of logging your SSIS component is producing.

read more

Continue reading

Octopus Deploy – Nuget Feed – 401 Unauthorized Pain

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 worked fine. Strange. Checked the Octopus deploy Nuget Feed connection ensuring user and password details were correct and same error. What???!

read more

Continue reading