How to quickly import a csv file into sql server

I was given a directory of problematic files. Each file had a pattern _id_ in it. I needed that id to then remove to a temporary table in T-SQL

For my side projects I have decided to go down the route of deploying to my own infrastructure instead of Paas mostly to foster getting comfortable with Linux. There is no definitive way of doing this , this post is joust one way that it can be done