[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.