如何在SSIS中插入超过255个字符的列 [英] How to insert a cloumn with more than 255 characters to excel in SSIS

问题描述

我有一个长度超过255个字符的表列，我需要将这个值插入到excel中。当列值超过255个字符时，我得到 Excel目标[15]：由于将数据流列长度为500的数据流列插入数据库列column1可能会导致截断

请帮助我找到一种方法，将一个超过255个字符的列插入到

解决方案

我想象你可以通过SSIS中的高级编辑器覆盖设置。

右键单击Excel目标>显示高级编辑器>输入和输出属性

Excel目标输入>外部列>列1（将长度更改为为500）。

这应该会阻止错误。

I have a table column with length more than 255 characters and I need to insert this value into excel. When ever the column value exceeds 255 characters, I am getting "Excel Destination [15]: Truncation may occur due to inserting data from data flow column "Copy of Column 0" with a length of 500 to database column "column1" with a length of 255." error at excel destination component.

Please help me to find a way to insert a column with more than 255 characters into an excel.

解决方案

I'd imagine you can overwrite the setting through the Advanced Editor in SSIS.

Right Click the Excel Destination > Show Advanced Editor > Input and Output Properties

Excel Destination Input > External Columns > Column 1 (Change Length to be 500).

This should stop the error.

这篇关于如何在SSIS中插入超过255个字符的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！