The package executes daily so I’m lucky I caught this in time. I Googled around and found this thread which advised a reinstall of SSIS. Unfortunately I didn’t have this luxury so I decided to do some digging. I found the location of the Execute Process Task dll file in the Choose Toolbox Items dialog.
Since the error was complaining about the task being unregistered I thought I’d try registering the dll in the GAC. First I executed the below command;
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322>gacutil /i "C:\Program Files\Micro
oft SQL Server\90\dts\tasks\Microsoft.SqlServer.ExecProcTask.dll"
Microsoft (R) .NET Global Assembly Cache Utility. Version 1.1.4322.573
Copyright (C) Microsoft Corporation 1998-2002. All rights reserved.
Failure adding assembly to the cache: Unknown Error
This failed because I was using a different version of the gacutil tool. As it turns out you have to use the appropriate version of gacutil for the dll. A quick 350MB download of the .NET Framework 2.0 Software Development Kit and I was ready to roll. I reattempted the above command with the correct version.
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin>gacutil /i "C:\Program F
iles\Microsoft SQL Server\90\dts\tasks\Microsoft.SqlServer.ExecProcTask.dll"
Microsoft (R) .NET Global Assembly Cache Utility. Version 2.0.50727.42
Copyright (c) Microsoft Corporation. All rights reserved.
Assembly successfully added to the cache
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin>
After this was registered I was able to edit the task with no problems. I couldn’t find any issues with any other task types so I was happy I didn’t go down the reinstall route.