导出在线数据库时出现问题 [英] Problem in export the online database

问题描述

您好..



我正在尝试将在线数据库导出到我的本地数据库，但它给出了这样的错误

Hello..

I am trying to export online database to my local database, but it given error like this

Setting Destination Connection (Error)
Messages
Error 0xc0202009: Destination 6 - Offers [97]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x800400FA.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x800400FA  Description: "All bound columns are read-only".
 (SQL Server Import and Export Wizard)
 
Error 0xc0202040: Destination 6 - Offers [97]: Failed to open a fastload rowset for "[dbo].[Offers]". Check that the object exists in the database.
 (SQL Server Import and Export Wizard)
 
Exception from HRESULT: 0xC0202040 (Microsoft.SqlServer.DTSPipelineWrap)

现在应该是什么我是为了解决这个错误吗？

Now what should I do for solve this error ?

推荐答案

你能获得在线数据库的备份副本并在本地恢复吗？



看起来SSIS包中的目标数据库不允许你插入。我猜这是你的本地数据库，所以你可以修改权限，允许插入并重试。

Can you get a backup copy of the online db and restore that locally?

Looks like the destination db in the SSIS package won't let you insert. I guess that's your local db so you can alter the rights on that to allow inserts and try again.

这篇关于导出在线数据库时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！