Getting the error when trying to create a maintenance plan in Litespeed:
Errors occurred.
Could not load file or assembly
Microsoft.SqlServer.SQLTask, version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91
or one of its dependencies. The system cannot find
the file specified.
The64 bit SQL server is missing a 32 bit (x86) assembly file.
Perform a search for the missing assembly (Microsoft.SqlServer.SQLTask .dll) in the path applicable to your version of SQL.
SQL 2005 - C:Program Files (x86)Microsoft SQL Server90
SQL 2008 - C:Program Files (x86)Microsoft SQL Server100
If the file is not found there you will need to copy it (not move) over from another server which does contain that file.|
Create a temporary folder and copy the dll file into it.
Copy the Microsoft tools, gacutil.exe and gacutil.exe.config, into the same temporary folder used in the prior step. Please note that gacutil.exe and gacutil.exe.config are included as part of the Microsoft .NET SDK. In attachment.
Open a command prompt and navigate to the temporary folder.
Run the command gacutil /i Microsoft.SqlServer.SQLTask .dll
Repeat these steps for any error reporting of missing assemblies.
Once complete, restart Litespeed.
If all of the above steps failed still, upgrade the client desktop to match the server side with LiteSpeed version.
Also try adding SQL Server 2008 x64 Integration Services and Backward Compatibility,this will automatically register the missing dlls.
