TABLE 3: Type2 Refresh DDQ Task Properties' Queries Tab Information
Query Type Query Destination Parameter
Insert INSERT INTO Prod
ucts_type2
(productid_app, productname, package, effective_date)
VALUES(?, ?, ?, ?)
productid_app
productname
package
effective_date
1
2
3
4
Update EXEC Destination..usp_Update_Products_type2
@productid_app = ?,
@productname = ?,
@package = ?
@effective_date = ?
 
productid_app
productname
package
effective_date
 
1
2
3
4
Delete UPDATE Products_type2
SET discontinued = 1
WHERE productid_app = ?
productid_app 1