기존에는 대략 이런식으로 처리..
BULK INSERT master.dbo.[ppn_20170405] FROM 'C:\Users\Administrator\Desktop\ppndata\albania.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR ='\r\n' )
암만 봐도 개행문자가 문제인듯한데..이렇게 변경하니까 됨..
DECLARE @bulk_cmd varchar(1000) SET @bulk_cmd = 'BULK INSERT master.dbo.[ppn_20170405] FROM ''C:\Users\Administrator\Desktop\ppndata\albania.txt'' WITH (FIELDTERMINATOR = '','', ROWTERMINATOR = '''+CHAR(10)+''')' EXEC (@bulk_cmd)