SSIS导出到Excel在预定义的表中 [英] SSIS Export to Excel Within a pre-defined table

问题描述

你好，



我已经为Excel做了一些有效的SSIS导出功能。

结果显示在多张表格中。

到目前为止，非常好。



其中一张被命名为Onboarding。

现在进入这张表Onboarding我预先定义了一个表：'tblOnboarding'。

我想在此表中输出结果。不幸的是，结果显示在表格下方/下方



在SSIS中;数据流; Excel目的地;属性'OpenRowSet';我将值''Onboarding $'更改为'Onboarding $！tblOnboarding'。



这似乎不正确。



有人可以帮我解决这个问题吗？



提前致谢！

Hello,

I have made some working SSIS export functionality to Excel.
The results appear in multiple sheets.
So far, so good.

One of the sheets is named "Onboarding".
Now in this sheet "Onboarding" I pre-defined a table: ‘tblOnboarding’.
I want the export-results in this table. Unfortunately the results appears underneath/below the table

In SSIS; Dataflow; Excel Destination; property ‘OpenRowSet’; I changed the value: ‘Onboarding$’ into ‘Onboarding$!tblOnboarding’.

This seems incorrect.

Can someone help me out in this matter?

Thanks in advance!

推荐答案

'进入'Onboarding

’ into ‘Onboarding

！tblOnboarding'。



这似乎不正确。



有人可以帮我解决这个问题吗？



提前致谢！

!tblOnboarding’.

This seems incorrect.

Can someone help me out in this matter?

Thanks in advance!

这篇关于SSIS导出到Excel在预定义的表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！