'anyname $'的开始行集失败 [英] The opening rowset for 'anyname$' failed
问题描述
我有一个SSIS包，我将在其中动态创建一个excel文件并将数据写入其中。我在数据流中使用Excel Destination组件并将数据（数据映射）传递到excel文件中。首先，我将创建一个CREATE TABLE脚本（例如，表名为'anyName'），因此Excel表格的名称：上会有'anyName $'。
下一页我将继续做变量映射。我没有问题执行包但但是在我尝试再次运行它之后的一段时间（几个小时，几天等），我会收到一条错误消息，如上面的标题。
有2个场景我会得到这个错误。一个是当我运行包时，另一个是当我尝试打开Excel目标组件中的映射部分时。
这是Excel目标组件中的错误吗？还是我只是错过了一些设置？
我尝试了什么：
1.重新配置Excel工作表的名称：，一切恢复正常。
Hi, I have a SSIS package in which I will create a excel file dynamically and write data into it. I am using Excel Destination component in data flow and pass data(mapping of data) into the excel file. At first, I will do a CREATE TABLE script(table name is 'anyName' for example) and thus the "Name of the Excel sheet:" would have 'anyName$' on it.
Next I will continue to do variable mappings. I have no problem executing the package but after some time(a few hours, a few days, etc) when I try to run it again, I would get an error message as above title.
There are 2 scenarios which I will get this error. One is when I run the package, another is when I try to open up the "Mappings" section in Excel Destination component.
Is this a bug in Excel Destination component? Or is it I simply missed out some setting?
What I have tried:
1. Reconfigure the "Name of the Excel sheet:" and everything back to normal.
推荐答案
'就可以了。
接下来我将继续进行变量映射。我没有问题执行包但但是在我尝试再次运行它之后的一段时间（几个小时，几天等），我会收到一条错误消息，如上面的标题。
有2个场景我会得到这个错误。一个是当我运行包时，另一个是当我尝试打开Excel目标组件中的映射部分时。
这是Excel目标组件中的错误吗？还是我只是错过了一些设置？
我尝试了什么：
1.重新配置Excel工作表的名称：，一切恢复正常。
' on it.
Next I will continue to do variable mappings. I have no problem executing the package but after some time(a few hours, a few days, etc) when I try to run it again, I would get an error message as above title.
There are 2 scenarios which I will get this error. One is when I run the package, another is when I try to open up the "Mappings" section in Excel Destination component.
Is this a bug in Excel Destination component? Or is it I simply missed out some setting?
What I have tried:
1. Reconfigure the "Name of the Excel sheet:" and everything back to normal.
这篇关于'anyname $'的开始行集失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
