none
Problem with SSIS RRS feed

  • 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?

     

    Wednesday, June 18, 2008 1:00 PM

All replies

  • 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.

     

    Wednesday, June 18, 2008 2:40 PM
    Moderator
  • 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

    Wednesday, June 18, 2008 2:54 PM