Xtract IS Query Preferences #
In the main window of the component, click Settings. The window “Xtract IS Query Preferences” opens.
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.
Treat “No Data Selected” as Error
If activated an error message is displayed when there is no data to be extracted.