一、使用insert bulk
insert into DATA_PLAT_EPG(TERMINAL_ID,PAGE_CODE, USER_ACCESS_TIME,CREATOR_ID,CREATE_TIME)
select TERMINAL_ID, PAGE_CODE, USER_ACCESS_TIME, 1,getdate() FROM OPENROWSET(BULK ${fileName},FORMATFILE=${formatFileName}) AS t1
二、使用bcp工具
三、使用SSIS工具