...
This property can be overridden at a job level by adding the parameter to the Custom Properties of a Data Import from a Database when ingesting the data. The parameter can also be set on the connection itself the connection itself to ensure that the sample data is read successfully.
...