sql-server - SSIS - 无法从 ODBC 源永久更改外部列

Question

在 SSIS 中，我试图从大型数据仓库中提取表数据，以便在 Excel 中进行一些分析。我写了以下查询：

SELECT journal_name        AS Journal_Name,
       division            AS DIV,
       account             AS Acct,
       cost_center         AS CC,
       effective_date      AS Effective_Date,
       effective_month     AS Month,
       effective_year      AS Year,
       posted_date         AS Posted_Date,
       source              AS Source,
       line_description    AS Line_Description,
       category            AS Category,
       entered_amount    AS E_Entered_Amount,
       entered_currency    AS E_Currency,
       functional_amount   AS Fuctional_Amount,
       functional_currency AS F_Currency
FROM   corp.source
WHERE  ( (division  = 'C301' )
         AND ( account  LIKE '%' )
         AND ( cost_center = '8D' )
         AND ( effective_month BETWEEN '01' AND '10' )
         AND ( effective_year  = '2019' ) )
ORDER BY posted_date

我正在使用 ODBC 源执行此操作，因为我从 Microsoft Access 工具中获取了 Oracle 连接器信息。我在 ODBC 屏幕中运行解析并查看预览并没有遇到任何问题。但是，当我尝试运行这个包以确保连接正常时，我得到：

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

Package Validation Error (Package Validation Error)

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

Error at Expression Task [Microsoft.SqlServer.ExpressionTask]: A null or empty expression is not valid.  Specify an expression.
Error at Expression Task: There were errors during task validation.

 (Microsoft.DataTransformationServices.VsIntegration)

------------------------------
Program Location:

   at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)

我不太确定是哪一列导致了错误。我过去处理过这些完全相同的数据，并且能够在使用 OLE DB 时将高级编辑器中的所有数据更改为宽字符串 [WSTR]，然后使用数据转换来修复它，并且效果很好。但是，每次我尝试在此 ODBC 源高级编辑器中更改外部数据的类型时，它都会不断重置为原始数据类型。有没有更好的方法来做到这一点，或者有什么原因我不能将传入的数据重置为 WSTR 来处理它？

谢谢。

标签： sql-serverdatabasessisetldata-conversion