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:
Solution:
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'.
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
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Why do I get the following error when executing a package under a SQL Server Agent job: "Failed to decrypt protected XML node "ServerPassword" with error 0x8009000B..."?
The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute method must succeed, and indicate the result using an "out" parameter. ... and also: Failed to decrypt protected XML ...When executing an SSIS package from the command line, it works properly. However, when I run the same package from the SQL Job Agent, it fails.
Make sure your SQL Job Agent user account has the following permissions: COZYROC SSIS+ installation folder (READ and WRITE). Windows temp folder (READ and WRITE). The default location is here: C:\Windows\TEMP Permission to access COZYROC registry ...Error Message: License: 'License.dat' file not found.
Action: When executing a package from SQL Server Agent job or when opening the COZYROC License Manager the following error was encountered: Error Message: License.dat file not found. Solution: There are two possible solutions: The error ...How To change the permissions on the License file from inherited to explicit
If the correct permissions are not given to the License.dat file, you could receive the following error message: "License file 'C:\Program Files (x86)\CozyRoc\SSIS\License.dat' has inappropriate permissions." In order to execute packages from the SQL ...Error message: Resource not specified
Action: When using the REST Source component with the REST connection configured for ServiceNow, I get the following error: Error Message: Resource not specified Solution: You don't have permission to access the ServiceNow resources. Ask your ...