I have 390 delimited text files collected from different sources. I have to load them in SQL Server. I don't want to use import and export wizard. I want to create a Bulk Copy Command Mechanishm through which data can be inserted into database.
Creating this would be really helpful for me. I am not able to see any sort of help for this on Google.
Please refer to me any google link or guide me, How can I do this. Please.
BULK INSERT TblTable FROM 'D:\PD_C1\1.txt' WITH ( FIELDTERMINATOR = '','', ROWTERMINATOR = ''\n'', )
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)