《BI那点儿事》数据流转换——OLE DB 命令转换

 CREATE TABLE SourceParametersForStoredProc ( Param1 INT, param2 INT ) 
 CREATE TABLE DestinationOLEDBCommandDest ( Dest1 INT, Dest2 INT )  
 
 INSERT SourceParametersForStoredProc
 VALUES ( 1, 2 ) 

CREATE PROCEDURE [dbo].[usp_DoubleInputValues]
    @input1 INT ,
    @input2 INT
AS 
    BEGIN

        SET NOCOUNT ON;

        INSERT  DestinationOLEDBCommandDest
                ( Dest1, Dest2 )
        VALUES  ( @input1 * 2, @input2 * 2 ) 
    END

GO