在SSIS包中将数据转换用于excel目标时，在excel列中使用单引号. [英] Single quote in excel column while using data conversion for excel destination in SSIS package.

问题描述

大家好，
在这里，我提出了SSIS中的新问题/问题.
我正在准备SSIS包，它将从存储过程中获取数据并将其导出到Excel.为了导出它，我正在使用Excel目标组件.
在Excel Destination组件之前，我已经添加了Data Conversion组件.
我观察到的是，当检查我生成的Excel时，在每一列中，包括标题都以单引号('')作为前缀.当我双击该excel的列时，只有该报价才会出现.

Hi Guys,
Here i come up with new question/issue in SSIS.
I am preparing SSIS package which will get data from Stored Procedure and export it into Excel. For exporting it, i am using Excel destination component.
Before Excel Destination component, i have added Data Conversion component.
What i observed is, when check my generated excel, in each columns, including headers have single quote('') as a prefix. When i double click on column of that excel, only that time that quote will apear. Do we have anything to not include such thing?

推荐答案

，您可以通过对所有unicode字符串强制使用字符串类型来解决该问题.高级属性->树状视图中的输入和输出"属性选择Excel目标输入"，外部列"

you can resolve it by forcing string type for all unicode strings.In SSIS - Right Click Excel Destination-> Advanced Properties -> Input and Output properties in tree view select Excel destination Input, External Columns

这篇关于在SSIS包中将数据转换用于excel目标时，在excel列中使用单引号.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！