Where can I specify the field data types for a csv connection? I’m guessing the connection process only looks at x amount of rows to guess the data types. Another ETL product I used to use gives the option to look at x amount or look at all. With the all option, there is an option to STOP for when the files are large.
Anywho, I can’t find anywhere that lets me specify the data type. The wizard is guessing wrong.