I assume you hv already made a connection to the database. Just add a command and click on command's properties. On Source of Data frame, select the Database Object as Table and Object Name as TableName. Then click on advance Tab, change lock-type as Optimistic. Apply the changes.