BPC 5.1 SP8 - Cannot install SSIS custom tasks

[Former Member]

All,

I'm working on a multi server environment: SQL/OLAP are on box A and application/web are on box B.

I've copied the files OSoftTask*.dll from <BPCFODER>\Websrvr\bin to <SQLFOLDER>\90\DTS\Tasks on box B.

Then I've selected "custom items..." and selected the boxes under "SSIS Control Flow Items". Tasks correctly appear on my toolbox.

I can also drag a task onto my SSIS project but when I try to edit it I get the message:

The task with the name DumpLoad Task and the creation name "Osoft.Services.Application.DataMgr.Task.SSISTaskDumpLoad, OsoftTashDumpLoad, Version=4.2.0.400, Culture=neutral, PublicKey Token=bf6c37fa78f5a648 is not registered for use on this computer.

Additional info:

I'm running SQL Server 64 bits;

The version # above looks weird. When I right click the DLL file I get version=5.0.509;

On a VM that I have with almost same installation (SQL 32 bit, single server) everything runs out of the box.

I've tried the same procedure on DB box but got the same problem.

Any clues?

Thanks

Paulo

[Former Member · Accepted solution]

Hi Paulo,

Here is the link that might guide you to the right direction [http://msdn.microsoft.com/en-us/library/ms141766(SQL.90).aspx].

I had the same issue just today... However, my application server is 32-bit, so I just moved everything there and everything worked fine.

You might try installing latest SQL Server SP3 - maybe there is a fix there...

I'd advice to do development on 32-bit and run SSIS on 32-bit as well.

Hope that helps,

Regards.

[Former Member]

Thanks.

I was able to solve the issue by changing the log on credentials of "SQL Server Integration services" to be BPC system administrator.

[Former Member]

I'm glad that you were able to find a workaround. I couldnu2019t do the same due to security restrictions.

Regards,

Akim

[Former Member]

Thanks for the warning, guys! This will save me a few hours of head-scratching.

[Former Member]

Hi Paul,

how did you manange exactly to install the SSIS component on a machine different from the App Server? I've tried to install the OSoftInstaller through the BPC admin account on my machine, but unsuccesfully (when I open BIDS and try to drag & drop a BPC component, it fails...)

Thanks

Daniele