BPC 10 MS: SSIS package error

[Former Member]

Hi experts,

We are trying to create a package with Visual Studio 2012 (SQL server 2012). We have already copied the ".dll" to the specific folder.

When we double click  anyone of the BPC task in the  "Control Flow" we receive that error "Cannot create Activex component".

Anyone has solved this issue?

Thank you in advanced!

Álvaro.

[Former Member · Accepted solution]

Hello experts,

Finally I "solved" the issue by installing Visaul Studio in the server and building the SSIS packages directly there. I am not able to make it work in my own PC.

Thank you for your time.

Regards,

Álvaro.

[Former Member]

Hi Alvaro,

probably you need to register the dll see please 2155212 - Error "Cannot create ActiveX component" happens when execute any packages in BPC MS 10.0 s...to follow the rules.

Please remember to search also in sap notes not only inside the forum and remember to close the thread when solved, eventually explaining your solution if you found yourself assigning assingning the "correct answer" this will help other user with same issue to find quickly how to solve.

Please avoid also to reopen old thread asking for a solution, if they didn't close correctly the thread explaining what was the solution 2 or 3 years ago they won't answer now almost surely to provide the solution that they probably have also forgotten.

Regards

     Roberto

[Former Member]

Roberto,

Thank you very much for your answer and advices.

The error I get is when I am trying to create the package, not when I execute it with the EPM run package. The problem is with the SSIS custom tasks from BPC I think...

I attach another image in order to clarify it.

Thank you very much.

Álvaro.

[Former Member]

Hi Alvaro,

then probably the bpc custom task are not correctly installed, you have to reinstall it from scratch following the install guide.

to verify it try to open a windows task it should open correctly.

Regards

     Roberto

[Former Member]

Hello Roberto,

It seems to be the correct answer. However, I have problems with the installation of the SSIS Client. When I try to install it in my pc, I receive and error of wrong user/password...

I tried to install it directly in the server but I receive the bellow message. I attach you the screenshot. Any idea?

Thank you very much.

Álvaro.

[Former Member]

Hi Alvaro,

just reboot the PC and retry to install, see please 1870857 - BPC Upgrade Hangs Assigning COM+ Components

Verify that all your sw is supported with your BPC version and sp here , if ok follow the install guide for the bpc custom tasks.

Regards

     Roberto

[Former Member]

Hi again Roberto,

I rebooted the server and I have been able to install the SSIS client. However I am no still able to do it in my PC.

As a consequence of that I still receive the error when I try to edit the BPC custom tasks in Visual Studio... Any more ideas?

Thank you all.

[Former Member]

Hi Alvaro,

maybe this note can help 2107011 - How to register BPC custom tasks in Visual Studio 2010-BPC 10 MS/BPC 10.1 MS , also  verify your sw version are all supported by your version and sp of BPC and follo the last chapter (8) of the installation guide.

Regards

     Roberto