The dialog below will open after clicking the Settings button.
Maximum numbers of rows to be extracted. 0 is unlimited.
Automatic String Conversion
All strings are converted into VarChar strings if the source system is non-Unicode, and all strings are converted into NVarChar if the source system is Unicode.
Convert Strings to VarChar
All strings are converted to VarChar regardless if the source system is Unicode or not.
Convert Strings to NVarChar
All strings are converted to NVarChar regardless if the source system is Unicode or not.
Use Variant Variable
The text field for the variant will open for user editing and an SSIS variable can be entered. A dynamic variant can be assigned this way.
Do not treat “No Data Selected” as Error
Defines whether an error message is given when there is no data to be selected.