SSIS:截断Excel目标 [英] SSIS: Truncate Excel Destination

问题描述

我正在创建一个SSIS包，该包将数据从SQL Server Source导入到Excel Destination.

I am creating a SSIS package that imporr data from a SQL Server Source to an Excel Destination.

如何在运行前截断电子表格? 我尝试了以下方式(使用Execute SQL Task失败.

How can one truncate spreadsheet before run? I tried the following way (using Execute SQL Task with no success.

推荐答案

Jet provider不支持截断或删除命令.您有3种解决方法:

Jet provider does not support neither truncate or delete command. You have 3 workarounds:

• 有一个空的excel模板，您可以在运行数据流之前克隆它，或者
• 在运行数据流之前，使用execute sql任务创建一个新的工作簿/选项卡
• 使用Drop Table TableCall_Log拖放工作表并创建一个新的工作表.您可以为此链接进行引用更多细节.

• Have an empty excel template that you clone before the running the dataflow, or
• Use execute sql task to create a new workbook/tab before running the dataflow
• Drop the worksheet using Drop Table TableCall_Log and create a new one. You can referer to this Link for more details.

有用链接

• 导入标头-线表进入Dynamic Excel目标II
• SSIS:动态生成Excel表/表

• Deleting Records in an Excel Sheet using SSIS
• Import Header-Line tables into Dynamic Excel destinations II
• SSIS: Dynamically Generate Excel Table/Sheet

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