How to programmatically import large numbers of records from a separated text file from a folder and insert into SQL Table

Question

Hi,

Can anyone provide some samples programmatically to import from a separate text file same is insert into a SQL Table with created timestamp.

Please ref my sample Bulk separate text file, it stored in D:\BulkImpFile\EM_20221031.txt (attached) 255948-em-20221031.txt

ref my SQL Table

If(OBJECT_ID('tempdb..#empMaster') Is Not Null)  
Begin  
    Drop Table #empMaster  
End  
  
Create Table #empMaster  
(  
    EmpCode Varchar(10),   
    EmpName Varchar(50),   
    DOB DateTime,   
 DPImage_Path Varchar(MAX),   
 Salary Decimal(15,2),  
 CreatedOnTimeStamp DateTime  
)  

Answer 1

Hi @Aypn CNN ,

You may use SSIS to import the data to table.

And then you may use sql agent job to run the package so that it could be an automated operation.

ssis-how-to-get-most-recent-file-from.html

sql-server-agent-jobs-for-packages

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

You can use the bcp Utility to import data into SQL Server.