when connecting to a SQL table with lots of data rows the data preview takes very long.
Is here also a possibility to use the function first x (e.g. 100) rows?
Maybe in the filter list box?
I don't think so there is any way from the wizard, but you know the table name, you can write the SQL directly in the script.
This will save a lot of your time.
If you don't know the fields, use *, to load all fields, and then use resident load to remove unwanted fields.
there is no option to load only 100
you can insert script first and write your script like
First 100 load your filed
write limit 100 in your sql statement
Is there any other way to speed up the preview in the wizard?