Skip to Content
0
Jun 24, 2008 at 07:23 PM

Microsoft .NET Data Provider for mySAP Business Suite

48 Views

Can some one explain me; where i should ask ABAP developer to put @variable in SAP so i can use it in my SSIS package.

The following SELECT statement returns all the columns in the SPFLI table for flights from New York to a city that is specified by the value of a variable.

To execute this statement, you must create a SAPParameter with the name @variable, specify its value, and add the SAPParameter to the SAPCommand object corresponding to the query.

[link|http://technet.microsoft.com/en-us/library/ms141761.aspx]

Code SnippetSELECT * FROM SPFLI WHERE cityfrom='NEW YORK' AND cityto=@variable