"Bi thing" data stream conversion--ole DB command Conversion

In the original: "Bi thing" data stream conversion--ole DB command Conversion

The OLE DB command executes an OLE DB command on the data rows in the data flow. It updates each row in the data table and stores the data that will be updated in the table beforehand. Or for a stored procedure with input parameters, these parameters can be stored in a data table without having to enter parameters each time.
Sample Data Preparation:

CREATE TABLE INT INT )  CREATETABLEINTint  )     INSERT   VALUES12

To create a stored procedure:

CREATE PROCEDURE [dbo].[usp_doubleinputvalues]    @input1 INT ,    @input2 INT as     BEGIN        SETNOCOUNT on; INSERTdestinationoledbcommanddest (Dest1, Dest2)VALUES(@input1 * 2,@input2 * 2 )     ENDGO

To create a data Flow task:





Result set:

"Bi thing" data stream conversion--ole DB command Conversion