sql-server - 如何将 SQL Server 2005 行导出到 excel？每次我这样做都会出错

Question

我有 SQL Server 2005，我正在尝试将表格导出到 Excel 文件中。

我右键单击我的数据库并单击“导出”。我通过向导并选择导出到 excel，然后我选择我要导出的一个表并点击完成。

我明白了

Messages

• Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x00040EDA.
  (SQL Server Import and Export Wizard)

• Error 0xc0209029: Data Flow Task: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (72)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (72)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard)

• Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - SchoolUsers" (61) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard)

• Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited. (SQL Server Import and Export Wizard)

它似乎导出一行然后就死了。我不知道为什么。

Answer 1

根据我的经验，这类问题几乎总是与数据类型转换有关。单击您选择源表的页面上的“编辑映射...”按钮并查看目标列的数据类型。