When my data flow gets to the OLE DB Destination it hits a performance roadblock. The Insert that SSIS generates for the step contains "returning rowid into :#var" which I would like to be rid of.
Ex. INSERT INTO TARGET_TABLE( "TABLE_NO", "ENTRY_NO", "TABLE_
DATA", "DTTM") VALUES (:1,:2,:3,:4) RETURNING ROWID INTO :5
Variables 1-4 are defined on the mapping page. I don't even know where variable 5 is coming from.
How can I make SSIS stop generating this superfluous code?