Deploying SSIS Package with reference to SAPbobsCOM

[seanarchernz]

Hi,

We have developed an SSIS package that references the DI-API via script components.  The solution works fine in development but fails once deployed.

The error on failure is:

Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. --> System.IO.FileNotFoundException: Could not load file or assembly 'Interop.SAPbobsCOM, Version=8.8.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependancies.  The system cannot find the file specified.

I have tried putting the Interop.SAPbobsCOM.dll in all the places where I suspected it might be call from including:

Package Path, .NET program files path, .NET Framework windows path, SQL Server DTS Binn, SQL Server Binn

I'm therefore wondering if it is the actual DIAPI DLL that it cannot find rather than the Interop file.

Has anyone else had/worked through this type of issue with SSIS packages and the DIAPI?

Regards,
Sean

[Former Member · Accepted solution]

Hi Sean,

I'vent tried SSIS using DI API SBO, can u tell me how to add the reference on the SSIS ?

and does it able to insert to SBO table using SSIS ?

for your case, I think, in the deployed PC, try to install SBO Client & DI API apps,

then try to run your ssis

if still error, try to delete your reference on the deployed PC, and add reference again.

Regards,

Hendra

[seanarchernz · Accepted solution]

Hi Hendra,

You can add the reference to the SAP DI-API from within the SSIS script component.  Using the DI-API you can update any of the business objects available.

I eventually found a solution which involved creating a signed version of the Interop DLL's to be deployed with the solution.  The following links (and the links within those links) gave me the information required.

http://stackoverflow.com/questions/13127549/how-do-i-use-com-reference-within-ssis-package

http://blogs.msdn.com/b/michen/archive/2007/04/22/com-references-within-an-ssis-script-component.asp...

Regards,
Sean