Ssis package not updating database
STEP 7: Drag and drop the Conditional Split Transformation from toolbox to data flow region and connect the Lookup Match Output as the source to Conditional split STEP 8: Double-click on it to provide the conditions.
Condition we used in this transformations is: ISNULL (LKP_Employee_ID).
In this example, we are Updating the values in the products table.In this example we will show you the steps involved in configuring the Incremental Load in SSIS.Before we start creating the SSIS package, Let us see the Source data Now let’s see the data inside the target table as well.SQL Statement we used in the above screenshot is Within the Column Mapping we have to assign the appropriate column name to the parameters.
TIP: First Question mark will be Parameter 0, Second Question mark will be Parameter 1 so on and so forth.
STEP 12: Double click on the OLE DB Command Transformation will open the Advanced Editor for OLE DB Command to configure it.