Skip to Content
avatar image
Former Member

.NET Connector in SSIS

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 07, 2007 at 12:29 AM

    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:

    how-to-use-microsoft-net-data-provider-for-mysap-i

    with respect,

    amit

    Add comment
    10|10000 characters needed characters exceeded

    • 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