bcp导入文本文件 求助

Question

导入文本文件时因为列数目不一致，因此作了格式文件，但是老是出错：遇到以外的EOF
文本如下
bscId;btsSiteManagerId;btsId;adjacentCellId;baseColourCode;bCCHFrequency;cellIdentity;cellType;hoMargin;locationAreaCode;microCellCaptureTimer;microCellSpareAdjacent1;microCellStability;mobileCountryCode;mobileNetworkCode;msTxPwrMax;networkColourCode;rxLevMinCell;synchronized;hoMarginDist;hoMarginRxLev;hoMarginRxQual;microCellSpareAdjacent2;directedRetry;forcedHandOverAlgo;standardIndicatorAdjC;timingAdvance;timeRejection;rxLevDLPBGT;bizonePowerOffset;hoMarginTrafficOffset;offsetLoad;offsetPriority;interferType;hoMarginAMR
35;0;0;0;0;1;48003;1;4;12524;0;;0;460;0;33;6;20;0;0;3;0;;19;0;0;0;10;63;63;0;0;1;0;-2
35;0;0;1;3;73;48002;1;4;12524;0;;0;460;0;33;6;20;0;0;3;0;;19;0;0;0;10;63;63;0;0;1;0;-2
格式文件如下：
8.0
38
1       SQLINT        1       4       ";"                       1     bscId                       ""
2       SQLINT        1       4       ";"                       2     btsSiteManagerId            ""
3       SQLMONEY      1       8       ";"                       3     btsId                       ""
4       SQLMONEY      1       8       ";"                       4     adjacentCellId              ""
5       SQLMONEY      0       8       ";"                       5     baseColourCode              ""
6       SQLMONEY      0       8       ";"                       6     bCCHFrequency               ""
7       SQLMONEY      0       8       ";"                       7     cellIdentity                ""
8       SQLMONEY      0       8       ";"                       8     cellType                    ""
9       SQLMONEY      0       8       ";"                       9     hoMargin                    ""
10      SQLMONEY      0       8       ";"                       10    locationAreaCode            ""
11      SQLMONEY      0       8       ";"                       11    microCellCaptureTimer       ""
12      SQLNCHAR      0       100     ";"                       12    microCellSpareAdjacent1     Chinese_PRC_CI_AS
13      SQLMONEY      0       8       ";"                       13    microCellStability          ""
14      SQLMONEY      0       8       ";"                       14    mobileCountryCode           ""
15      SQLMONEY      0       8       ";"                       15    mobileNetworkCode           ""
16      SQLMONEY      0       8       ";"                       16    msTxPwrMax                  ""
17      SQLMONEY      0       8       ";"                       17    networkColourCode           ""
18      SQLMONEY      0       8       ";"                       18    rxLevMinCell                ""
19      SQLMONEY      0       8       ";"                       19    synchronized                ""
20      SQLMONEY      0       8       ";"                       20    hoMarginDist                ""
21      SQLMONEY      0       8       ";"                       21    hoMarginRxLev               ""
22      SQLMONEY      0       8       ";"                       22    hoMarginRxQual              ""
23      SQLNCHAR      0       100     ";"                       23    microCellSpareAdjacent2     Chinese_PRC_CI_AS
24      SQLMONEY      0       8       ";"                       24    directedRetry               ""
25      SQLMONEY      0       8       ";"                       25    forcedHandOverAlgo          ""
26      SQLMONEY      0       8       ";"                       26    standardIndicatorAdjC       ""
27      SQLMONEY      0       8       ";"                       27    timingAdvance               ""
28      SQLMONEY      0       8       ";"                       28    timeRejection               ""
29      SQLMONEY      0       8       ";"                       29    rxLevDLPBGT                 ""
30      SQLMONEY      0       8       ";"                       30    bizonePowerOffset           ""
31      SQLMONEY      0       8       ";"                       31    hoMarginTrafficOffset       ""
32      SQLMONEY      0       8       ";"                       32    offsetLoad                  ""
33      SQLMONEY      0       8       ";"                       33    offsetPriority              ""
34      SQLMONEY      0       8       ";"                       34    interferType                ""
35      SQLMONEY      0       8       ";"                       35    hoMarginAMR                 ""
36      SQLDATETIME   0       0                                  0    importtime                  ""
37      SQLUNIQUEID   0       0                                  0    id                          ""
38      SQLMONEY      0       0                                  0   OMCID                        ""
数据表如下：
CREATE TABLE [dbo].[ADJCHO] (
[bscId] [int] NULL ,
[btsSiteManagerId] [int] NULL ,
[btsId] [money] NULL ,
[adjacentCellId] [money] NULL ,
[baseColourCode] [money] NULL ,
[bCCHFrequency] [money] NULL ,
[cellIdentity] [money] NULL ,
[cellType] [money] NULL ,
[hoMargin] [money] NULL ,
[locationAreaCode] [money] NULL ,
[microCellCaptureTimer] [money] NULL ,
[microCellSpareAdjacent1] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[microCellStability] [money] NULL ,
[mobileCountryCode] [money] NULL ,
[mobileNetworkCode] [money] NULL ,
[msTxPwrMax] [money] NULL ,
[networkColourCode] [money] NULL ,
[rxLevMinCell] [money] NULL ,
[synchronized] [money] NULL ,
[hoMarginDist] [money] NULL ,
[hoMarginRxLev] [money] NULL ,
[hoMarginRxQual] [money] NULL ,
[microCellSpareAdjacent2] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[directedRetry] [money] NULL ,
[forcedHandOverAlgo] [money] NULL ,
[standardIndicatorAdjC] [money] NULL ,
[timingAdvance] [money] NULL ,
[timeRejection] [money] NULL ,
[rxLevDLPBGT] [money] NULL ,
[bizonePowerOffset] [money] NULL ,
[hoMarginTrafficOffset] [money] NULL ,
[offsetLoad] [money] NULL ,
[offsetPriority] [money] NULL ,
[interferType] [money] NULL ,
[hoMarginAMR] [money] NULL ,
[importtime] [datetime] NULL ,
[id]  uniqueidentifier ROWGUIDCOL  NULL ,
[OMCID] [money] NULL 
) ON [PRIMARY]
GO
调用实：EXEC master..xp_cmdshell 'bcp ydtx.dbo.adjcho in c:\adjcho.txt -f c:\adjcho.fmt -S"cj04" -U"sa" -P"sa"'求救啊

Answer 1

楼主，建议在调用BCP时建立Log。在Log中可以发现具体出错原因，有助解决问题。
echo ===================================================== >> log\PASBCP.Log
echo 开始将jx_actvth.7370导入到表jx_actvth >> log\PASBCP.Log
bcp CMPAS.dbo.jx_actvth in data2/jx_actvth.7370 -c -q -SYAOMING -U"sa" -P"sa" -t"|"  >> log\PASBCP.Log

Answer 2

SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]在 BCP 数据文件中遇到的意外的 EOFlog文件中只有这个啊 
帮忙看看