in reply to loading a txt file into SQL Server

This isn't really a Perl question. You should read the docs for your SQL server. Different SQL servers have different commands.

SQL "BULK INSERT" or MySQL "LOAD DATA" for example.

In Section Seekers of Perl Wisdom