Close

Windows Server 2008

Resolving SQL Server Agent Job Issue – System.InvalidOperationException: Unable to generate a temporary class (result=1)

Below is the final error message l kept getting when setting up a SQL Server Agent Job which ran an SSIS package. The SSIS package is designed to create a folder in a network share as well as copy some files into that folder.   Message Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 […]

Read More

Windows Server 2008 R2 – Disable UAC

Steps to disable UAC on Windows Server 2008 R2. In some situations, UAC hinders full functionality of some SQL Server components such as SSIS 2008/2012/2014 Click on Start button Control Panel User Accounts Change UAC Settings Slide down to Never notify Select OK Select Yes Restart Computer/Server  

Read More