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