Error Message: License file C:\Program Files (x86)\CozyRoc\SSIS\License.dat is busy.
Deployed package to SSIS catalog
Ran it and noticed it was running very slow – it used to take ~50 seconds but was now taking ~1,000 seconds
Looked at SSIS message log and saw several messages saying “access to License.dat is denied”
Error Message:
License file 'C:\Program Files (x86)\CozyRoc\SSIS\License.dat' is busy.
Solution:
Went to the CozyRoc folder in ProgramFiles and gave our SQL Agent service account full read/write access
Make sure your proxy account has permissions to access the following:1. The SSIS+ installation folder. (see error path above)
2. One of the following registry keys, depending on whether you're using the 32 bit or the 64 bit version:
32bit - HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc\SSIS
64bit - HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS