Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-12-30 : 02:21:20
|
hitext file so005283 BAK? BA? S?HIYY? IDAR?SI 2 100 00010130606 1000 000 000 000 000 1000 1020200*AVIRTEL MMC 2 000 3803710 -200 000 000 000 000 -200 01--- I created a tableCREATE TABLE idare_abune(Test char(6), Test1 char(60), Test2 char(2), Test3 char(4), Test4 char(26), Test5 char(11), Test6 char(12),Test7 char(8), Test8 char(7), Test9 char(7),Test10 char(11), Test11 char(5), Test12 char(7),Test13 char(3))2--------- I created a fmt fileexec xp_cmdshell 'bcp ats342.dbo.idare_abune format nul -S XIRDALAN-SERVER -f "c:\temp\idare_abun.fmt" -c -T' 3----------I changed fmt file '\t' to ''4---- BULK INSERT idare_abune FROM 'C:\Documents and Settings\?????????????\??????? ????\obrabotka\OBOROTKA-092.list.txt' WITH ( FORMATFILE = 'c:\temp\idare_abun.fmt' )----------------- i get error -------The statement has been terminated.http://sql-az.tr.gg/ |
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2013-12-30 : 03:24:43
|
the number of column from the text file and table seem different |
|
|
|
|
|