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!