分享

写回答

发帖

[提问] 用DPW导入数据到sql server 2005出错

GoDaddy GoDaddy 1045 人阅读 | 1 人回复

发表于 2010-10-24 11:31:28 | 显示全部楼层 |阅读模式

用DPW导入本地数据到GD的数据库时有的表能导入,有的表导入出错:

标题: SqlPubWiz
------------------------------

尝试发布表 [dbo].[price] 数据时出错

------------------------------
其他信息:

OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].title'.  (System.Web.Services)

------------------------------
按钮:

确定
------------------------------

不知道为什么?那位遇到过吗?

回答|共 1 个

7788ss 该用户已被删除

发表于 2010-10-24 11:33:35 | 显示全部楼层

详细的错误信息:

===================================

尝试发布表 [dbo].[price] 数据时出错 (SqlPubWiz)

------------------------------
程序位置:

   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.PublishToWebWriterProvider.PublishData(DataSet dataSet, String tableName)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.PublishToWebWriterProvider.WriteObject(Object obj)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptWriter.WriteObject(Object obj)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptObjectContainer.AppendDataScriptFragment(ScriptWriter scriptWriter, IEnumerable fragment)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptObjectContainer.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptedObjectCollection.ScriptAll(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.DependencyScriptHandler.ScriptCore(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptHandler.Script(ScriptWriter scriptWriter)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.SingleScriptTarget.OnScriptingFinished(Object source, EventArgs e)
   在 System.EventHandler.Invoke(Object sender, EventArgs e)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptProcessor.OnScriptingCompleted()
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptProcessor.GenerateScript()
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptingEngine.GenerateScript()
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptingDriver.GenerateScript()
   在 Microsoft.SqlServer.Management.SqlManagerUI.GenerateScriptMaker.DoScript()
   在 Microsoft.SqlServer.Management.SqlManagerUI.GenScriptWizForm.Script()

===================================

OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].title'.  (System.Web.Services)

------------------------------
程序位置:

   在 System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   在 System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   在 Microsoft.SqlServer.Tools.HostingServices.PublishService.PublishData(DataSet ds)
   在 Microsoft.SqlServer.Management.SqlManagerUI.Scripting.PublishToWebWriterProvider.PublishData(DataSet dataSet, String tableName)
您需要登录后才可以回帖 登录 | 注册

本版积分规则