运行命令得到下面的错误. 我只有表结构, 希望能看到数据. 哪位高手帮帮我呀.先谢谢啦
bcp SD_Main..Business_Hours in C:\Temp\IVR_Common_Configuration.
dbo.Business_Hours.bcp -n -S 10.1.1.1 -TStarting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-fil
e0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
bcp SD_Main..Business_Hours in C:\Temp\IVR_Common_Configuration.
dbo.Business_Hours.bcp -n -S 10.1.1.1 -TStarting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-fil
e0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
EXEC master..xp_cmdshell 'bcp 数据库..表名 out c:\temp1.txt -c -q -S"." -U"sa" -P""'EXEC master..xp_cmdshell 'bcp CAS2004..HGZ_LIAOJIAN out c:\temp1.txt -c -q -S"." -U"sa" -P""'--从文件中导入数据到数据库对应表中
EXEC master..xp_cmdshell 'bcp CAS2004..HGZ_LIAOJIAN in c:\temp1.xls -c -q -S"." -U"sa" -P""'
EXEC master..xp_cmdshell 'bcp CAS2004..HGZ_LIAOJIAN in c:\temp1.txt -c -q -S"." -U"sa" -P""'还有启用xp_cmdshellUSE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO
RECONFIGURE WITH OVERRIDE
--关闭xp_cmdshell
USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 0
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO
RECONFIGURE WITH OVERRIDE
bcp copy in partially failedbcp.sql的内容入下:bc||1||2010-07-27 14:40:00&&
bc||1||2010-07-27 14:40:00&&
bc||1||2010-07-27 14:40:00&&
bc||1||2010-07-27 14:40:00&&
bc||1||2010-07-27 14:40:00&&
bc||1||2010-07-27 14:40:00&&
bc||1||2010-07-27 14:40:00&&
bc||1||2010-07-27 14:40:00&&bcp命令如下bcp tt in ./bcp.sql -Unms -Penetmanager -SSYBASE -c -t'||' -r'&&' -b10 >./err.txt 2>&1行结束符设置的是 && ,测试了半天都是还报那个错误。折腾了半天,结果想起来在每行的结束处有个看不见的换行符 \n,命令改成bcp tt in ./bcp.sql -Unms -Penetmanager -SSYBASE -c -t'||' -r'&&\n' -b10 >./err.txt 2>&1问题得以解决了。果然是看不见的回车符惹的祸本文出自 “绿色心情 & 蓝色幻想” 博客,请务必保留此出处http://jeyochen.blog.51cto.com/828868/507328
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (c) 1991-1998, Microsoft Corp. All Rights Reserved.
Version: 9.00.5000.00没有自增列,以下是结构.
CCId varchar(10)
DayOfWeek varchar(9)
OpenHour Datetime
CloseHour Datetime
也可能你的文件里面尾部有空行或者你用了格式文件,格式文件写得不好,也容易产生这个问题不信你先导出(假如你的表有几行数据), 然后在导入 肯定不会错的。bcp SD_Main..Business_Hours out C:\Temp\IVR_Common_Configuration.
dbo.Business_Hours.bcp.new -n -S 10.1.1.1 -Tbcp SD_Main..Business_Hours in C:\Temp\IVR_Common_Configuration.
dbo.Business_Hours.bcp.new -n -S 10.1.1.1 -T
CREATE TABLE [tb]([aa] VARCHAR(8000),[bb] VARCHAR(8000),[cc] VARCHAR(8000),[dd] VARCHAR(8000))这种的
然后导入看有错没,如果成功了 你检查一下列里面的数据。
前几个成功导入的表没有datetime类型字段文本格式打开数据文件,象下面的样子 FOT Tuesdayþÿÿÿ Öƒ þÿÿÿ —I FOT Mondayþÿÿÿ Öƒ þÿÿÿ —I FOT Wednesdayþÿÿÿ Öƒ þÿÿÿ —I FAP Thursdayþÿÿÿ Öƒ þÿÿÿ —I FIX Sundayþÿÿÿ Öƒ þÿÿÿ Öƒ