SSIS以50000条记录格式对应的选项卡的形式输出excel格式? [英] SSIS output excel format in form of 50000 record format corrosponding tab ?

问题描述

Excel输出应采用标签格式..
tab = 0-50000
制表符= 50000-10000
请帮助我..

Excel ouput should in tab format..
tab= 0-50000
tab= 50000-10000
Please help me..

推荐答案

虽然我看不到将数据划分为单独的工作表没有任何好处(实际上，我认为这样做会使数据处理更加困难) ，就可以做到.

根据如何将数据划分为不同的工作表，您可以使用例如execute SQL任务.例如，看一下此对话: http://www.sqlservercentral.com/Forums/Topic487837-19 -1.aspx [ ^ ]

While I see no benefit in dividing the data into separate sheets (actually I believe that it''s making the data handling much harder), this can be done.

Depending how you divide the data to separate sheets, you can for example use a execute SQL task. For example have a look at this conversation: http://www.sqlservercentral.com/Forums/Topic487837-19-1.aspx[^]

这篇关于SSIS以50000条记录格式对应的选项卡的形式输出excel格式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！