• Brian Shaw - Tuesday, April 10, 2018 12:29 PM

    Thanks Steve.
    The SQL agent is running with a service account in the administrators group so its not a permission thing, but that got me thinking.
    I tried running the package as the service account with DTExec.exe (32 and 64 bit) and received the same error with both, so its not related to SQL agent.

    I fired up Process Monitor and discovered it was looking for Microsoft.AnalysisServices.AdomdClientUI.dll in a directory where it didn't exist. I found this DLL, copied to where it wanted it and it works now. It was looking for it in several places, I copied the file from D:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn to D:\Program Files\Microsoft SQL Server\140\DTS\Binn. I know one directory is for 32 bit DLLs and the other is for 64 bit DLLs, but I tried it and it worked.

    As far as I am concerned this is a bug in the installation process or DTExec.exe.

    -Brian

    Excellent that you were able to track it down, but I have to wonder if the PATH environment variable might be where the problem started.   The order in which the path elements occur can sometimes be critical to finding files, and while copying a file to where it's "expected" can solve the problem, it may be that the PATH just isn't set right, or failed to be updated to the new file location by the most recent product upgrade installation or other similar install.   I'd check your current PATH environment variable to see if that file would be found in any of the folders listed.   Alternatively, there may just be a registry entry that just points to the wrong folder, very possibly for the same reasons I suggested were possible causes of PATH problems.   Admittedly, the registry is a dangerous place to go, and one would want to verify the correctness (or incorrectness) of what you have before making a change, as well as have a backup of same before making a change.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)