i am new with this

can you explain me if

i have dynamic file like 123.txt ,456.csv and like that and want to load them in to sql server

How can i achive that.??