You specify data movement options on the model property sheet.
-
Right-click the model item in the Browser and select Properties from the contextual menu.
-
Click the Data Movement tab and enter the appropriate values for the model as a whole.
-
[optional] To override these global data movement options for a specific table, open its property sheet and enter table-specific values on the Data Movement tab. This tab also allows you to specify a table-specific dump file for importing into the table