SSIS Excel目标空白 [英] SSIS Excel destination blank

问题描述

我正在调试一个以SQL Server数据开头的SSIS程序包，将其转换并将其放入Excel文件中.我在工作中经常这样做，以前从未遇到过此问题:没有行被写入Excel文件.我将数据查看器附加到通向Excel目标的优先级约束，然后看到数百行数据流向目标.包执行完后，我打开Excel文件，没有数据！

I am debugging an SSIS package that starts with SQL Server data, transforms it, and puts it into an Excel file. I do this frequently in my work, and have never encountered this issue before: no rows are written to the Excel file. I attached a data viewer to the precedence constraint that leads to the Excel destination, and I see hundreds of rows of data flowing to the destination. When the package finishes executing, I open the Excel file and there is no data!

推荐答案

请记住，从数据流任务看似已在调试模式下成功完成的数据流任务可能要花费一些时间(几分钟)，然后再写入Excel文件完成.

Bear in mind that it can take some time (many minutes) from a data flow task appearing to have successfully completed in debug mode before the write to the Excel file is completed.

在执行带有Excel输出的数据流任务时，我遇到了类似的情况，并且发现即使数据流目标块在调试器中变为绿色(通常很好地表明，对于其他文件类型，例如csv，一切都已完成))Excel文件中没有任何内容.只有当我开始在输出"窗口中等待此消息时，我才能成功看到结果:

I just encountered a similar scenario when executing a data flow task with an Excel output, and found that even though the data flow destination block turned green in the debugger (normally a good indication that everything's finished for other file types, e.g. csv) there was nothing in the Excel file. It was only when I started waiting for this message in the Output window that I could successfully see the results:

Information: 0x4004300B at Export data for checking, SSIS.Pipeline: "component "Excel Destination" (5918)" wrote 265488 rows.

我想在最终输出阶段的某个地方会发生缓冲.

I guess there's some buffering going on somewhere in the final output stage.

我的线索是，当整体运行程序包时，数据流任务中的所有内容都变为绿色，但程序包流显示数据流任务仍为黄色(进行中")，直到真正完成为止.

My clue was that when running the package as a whole, everything in the data flow task turned green, but the package flow showed the data flow task as still yellow ("in progress") until it was really finished.

这篇关于SSIS Excel目标空白的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！