Bulk insert from File SQL Server
For CSVs bulk insert ycsoftware.dbo.ycsoftware from ‘\\192.168.1.1\c$\ycsoftware\files\data.txt’ WITH ( FIRSTROW = 2, FIELDTERMINATOR = ‘\t’, ROWTERMINATOR = ‘\n’, TABLOCK ) For TSVs bulk insert ycsoftware.dbo.ycsoftware from ‘\\192.168.1.1\c$\ycsoftware\files\data.txt’ WITH ( FIRSTROW = 2, FIELDTERMINATOR = ‘,’, … Read more