--表1 开户级别表 534848 852363 1387211
exec master..xp_cmdshell 'BCP ##jibie in
d:FTP hreetable est.txt -c -t"|" -r0x0A -T'
--表2 利率表 224 457
bulk insert ##lilv
from 'D:FTP hreetableF_CM_KITP_JIZHLL_20150930.dat'
with
(
codepage=65001,
fieldterminator='0x03',
rowterminator='0x0A'
)
--表3 机构表 97 63 160
bulk insert ##jigou
from 'd:FTP hreetableF_PT_ORG_KBRP_JGCSHU_20150930.dat'
with
(
codepage=65001,
fieldterminator='0x03',
rowterminator='0x0A'
)