Problem with SSIS

Question

I created an SSIS package that processes a cube and its dimensions. At the end of the package There is an "Execute Process Task" that calls an executable that sends an e-mail. It worked fine for a while and recently it stopped sending e-mails. When I checked the package I recieved the following error

 

The task with the name "Send Email" and the creation name "Microsoft.SqlServer.Dts.Tasks.ExecuteProcess.ExecuteProcess, Microsoft.SqlServer.ExecProcTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" is not registered for use on this computer. Contact Information: Cube Processing Email Notification

 

Could some one advise me on how to resolve the problem?

 

Answer 1

In my view, your SSIS isn't in a good state. There may be some conflicts of your enviroment. Only I can think about is to repair the installation of SSIS. Or uninstall-install it. This way is without many intellegence but it may be fast way to solve the problem.

 

Answer 2

I will suggest that you copy the SSIS to your test environment and execute. This will allow you to debug the process. Have you of recent alter the registry to accomondate any system changes?

 

If not I will suggest the first option.  Write another package to send mail and compare the error.

 

kind regards