.NET Connector in SSIS

[Former Member]

Hello,

I have a question regarding the integration of SAP.Connector DLL´s (SAP.Connector.dll & SAP.Connector.Rfc.dll) into the SQL Server 2005.

Target is to use the SAP .NET connector inside SSIS.

I want to use the Script-Task object in SSIS in order to communicate with SAP. The problem is the missing reference to the SAP.connector DLL´s:

I tried the following step:

SQL Server 2005 -> System Database -> Assembly -> Add Assembly

When I try to add SAP.Connector DLL I receive the follwing message (translated from German):

The 'system.drawing, version=1.0.5000.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.'-assembly was not found in SQL-catalogue.

I searched the forum for more information about SSIS, but I could not find so much information about this.

I think the problem is the limited .NET framework inside the SQL Server, the SAP connector classes use more parts of the framework than the SQL Server can offer... .

Is this a deadlock or is any workaround available?

Thanks in advance!

Richard

[Former Member]

Hi Richard,

have you tried using the Microsoft .NET Data Provider for mySAP with Visual studio 2003 ?

please read a previous thread on the topic:

with respect,

amit

[Former Member]

Hello Amit,

thanks for your link.

Now I understood how to connect SSIS to SAP

I have to prepare our SAP system for the usage of this provider.

Best regards,

Richard