Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error CS2008: No inputs specified"

Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error CS2008: No inputs specified"

Action:

      When running an SSIS package under the SQL Job Agent, the following error is encountered.


Error Message:

      "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error CS2008: No inputs specified"

Solution:

      Make sure your SQL Job Agent user account has permissions to the Windows temp folder (READ and WRITE). The default location is: 'C:\Windows\TEMP'.

How to find the SQL Job Agent user account:

1.     The SQL Agent uses whatever is assigned as the login on the Windows Service.

2.     To access Windows services, click the start menu and type 'Services'.



    3.     Under the ‘Log On As’ column, ‘NT Service\SQLSERVERAGENT’ is the account the SQL Server Agent is using.

Give the SQL Job Agent user account permissions to C:\Windows\Temp:

1.     Right click C:\Windows\Temp folder and select ‘Properties’.

2.     Select the Security tab àClick the ‘Edit’ button.


 

3.     Click the ‘Add’ button.


 

4.     Enter the object name to select: NT Service\SQLSERVERAGENT à Click ‘Check Names’ button à Click ‘OK’ button.


 

5.     Select the ‘SQLSERVERAGENT’ user à Click the ‘Read’ and ‘Write’ checkboxes à Click the ‘Apply’ button à Click the ‘OK’ button.


 

6.     Verify the permissions were set and click the ‘OK’ button to close the ‘Properties’ window.

 

 

 

 



    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.