This is unbelevable.. I've been struggeling a bit with getting distributed transactions to work, but yesterday I finally got it all working.
A couple of hours later (yesterday evening) there was a service window in the organisation and a couple of hotfixes etc was installed in the server (Win2k3).
This morning when I tried to launch the job (an SSIS package) I get the error message "Unable to load package". If I run the package as a cmd program I get a permission denied error. The package is stored in SSIS package store (MSDB\...\). I have added the account running the job-step in the local administrators group and also made it sys_admin of the SQL-database, but with the same result (package could not be loaded).
I have also tried to import the package again since I thought it might have been corrupted, but no success.
Any idas?
I would find out what those hotfixes were, what they do, and what problems they were meant to solve.
-Jamie
|||
It was
KB922616 - Security problem in HTML
KB917344 - Security problem in JScript
KB921398 - Windows explorer problem
I can't see any of them should affect this... I don't think they were ment to solve any spesific problem(s). I guess more or less all security patches for the servers are installed here (I'm not responsible for the server patching).
However, I'm not so sure the hotfixes are responsible. Perhaps the reboot triggered something, some policy, some settings that were changed but didn't take effect until the reboot or whatever...
Guess I could try to remove the patches and see if it helps.
|||COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\msisip.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\dllcache\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\dllcache\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\dllcache\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\dllcache\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\dllcache\msisip.dll"
C:\WINDOWS\$MSI31Uninstall_KB893803v2$(2
