如何在falt文件目标中合并两列

问题描述

嗨每一个



i我是ssis.i的新手，我正在使用excel源码，它有示例数据。我有这样的节目输出。我必须合并两个列成一列并显示到平面文件目的地。

如何做到这一点任何人都告诉我，请它紧急





感谢你，

Hi Every one

i am new to ssis.i am using excel source and it has sample data.i have show output like this.i have to merge two columns into one column and display it into flat file destination.
how to do that any one tell me please it's urgent


thanking you,

推荐答案

Workbook wb = new Workbook();
Worksheet worksheet = wb.Worksheets[0];
worksheet.Cells.Merge(0, 0, 1, 2);  //Parameters of Merge method are firstRow, firstColumn, totalRows, totalColumns

这篇关于如何在falt文件目标中合并两列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！