[mahalol]

This may be exactly what I need. I want to point it to a csv file and generate a schema of what type of data is in each column.

I do want some flexibiliy though, for example, if a certain column is filled with 9 digit numbers, starting with 0 then treat it as string.

Will have a look at it, thanks for the link!

[OldHand2018]

Not the solution you are looking for, but…

SSIS will generate a schema for a CSV file and then let you modify any column you choose (including what you described). All it does, really, is generate the schema that the “SQL Server bulk copy” tool interprets.

[mahalol]

Can I do this programmatically? I need to automate some manual processes.

[OldHand2018]

SSIS? Yes, of course.

It’s standard Microsoft. You can do a million things with it and it can be integrated into the entire Windows ecosystem, but go too far and you are locked in. PS, the version control experience is bad. Really bad.

For casual use, by all means use it. It’s powerful and high performance. For real production use, perhaps try to find something else.