cancel
Showing results for 
Search instead for 
Did you mean: 

.Net and SQL Server 2005

Former Member
0 Kudos

We are using the SSIS service within SQL Server 2005 to execute a custom function module within our SAP system. We're using the .NET framework data provider for mySAP Business Suite provided by Microsoft.

We have been successful in setting up the connector and executing the function module within our 4.6c system. However, when executing the same function module within our 4.7 system we are unable to retrieve the data. The 4.7 system is unicode enabled where as the 4.6c is not. When previewing the data returned from the function module the output is retrieving double the amount of data within each field (char3 field shows 6 characters).

Appreciate if anyone can assist in resolving this issue.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Greg,

how are you doing ?

please elaborate on the issue with examples of the querry and the data

with respect,

amit

Former Member
0 Kudos

Amit,

The query is 'EXEC xxxx' where xxxx is our RFC enabled function module. There are no input parameters. The output is a table structure with 22 fields, most fields are similar to what is found in sglwlpfnrm structure as we are trying to retrieve r/3 statistically data for monitoring r/3 performance. We have been executing this same function module on our 4.6c systems for several months via the same set up into SQL Server with no issues. When we have tried to set this up against our 4.7 systems we get the following preview error:

'Conversion from SAP type 'RFCTYPE_BCD' to .NET type failed'

We are unsure as to how to resolve this issue, but believe it to be related to unicode set up on our 4.7 systems. When doing a sql and rfc trace against the 4.7 systems, it appears that the function module is called successfully and data is being sent back, however, its unsuccessful on SQL server and no data is returned.

We have tried all the options that we know and are now stuck. Any assistance is appreciated.

Greg