SQL Server 导出错误：0xc0202009、0xc0209029 和 0xc0047022

Question

我正在尝试从 SQL Server 导出一些信息。 SQL 在 SQL Management Studio 中运行良好，但是当我尝试导出时，它会出现以下错误。 我之前遇到过类似的问题，添加该

SET ANSI_WARNINGS OFF

行修复了它。这次该线路不起作用。

编辑： 我尝试过使用 SQL SELECT * FROM Table 但仍然收到错误。

SQL 基本上是：

SELECT [Table]
      , CASE WHEN [UserID] IS NULL THEN '' ELSE [UserID] END AS [UserID]
      , CASE WHEN [fieldname] IS NULL THEN '' ELSE [fieldname] END AS [fieldname]
      , CASE WHEN [fieldname] IS NULL THEN '' ELSE [fieldname] END AS [fieldname]
      , CASE WHEN [fieldname] IS NULL THEN '' ELSE [fieldname] END AS [fieldname]
                             ... more ...
      , CASE WHEN [fieldname] IS NULL THEN '' ELSE [fieldname] END AS [fieldname]
      CASE WHEN [fieldname] IS NULL THEN '' ELSE [fieldname] END AS [fieldname]
  FROM Table

错误：

Messages
Error 0xc0202009: Data Flow Task 1: 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 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "Destination Input" (174)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (174)" 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 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Destination - Query" (163) failed with error code 0xC0209029 while processing input "Destination Input" (174). 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)

Answer 1

我把这归因于微软是个白痴。

我有一些日期字段。除 1790 年以来的日期外，所有日期都可以正常导出。如果我将所有早于 1800 年的日期转换为空白，则导出可以正常工作。

这些错误与这个问题有什么关系，你明白了。

一路走好 M$