当我保存 SSIS 包时，更改会丢失
我有一个带有执行 SQL 任务的 SQL Server 2005 SSIS 包。我编辑 SQL 语句，单击“确定”以进行更改。我返回执行 SQL 任务，更改已经生效。伟大的。
我现在去保存包裹。我点击保存。我回头查看执行 SQL 任务，发现更改已丢失。
这是怎么回事？我该如何阻止它？
I have a SQL Server 2005 SSIS package with an Execute SQL task. I edit the SQL statement, go through the OKs to make the change. I go back in to the Execute SQL task- and the changes have taken hold. Great.
I now go to save the package. I click save. I look back in the Execute SQL task, and the changes have been lost.
What is going on here and how can I stop it?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
对于 SSIS 包的可重用性和基于模板的开发来说，这是一个很好的功能。我们一直使用它。
This is a nice feature for reusability and template based development of SSIS packages. We use it allt he time.
我有同样的问题。原因是我使用了包含所有可执行文件的配置文件，而 sql 代码只是存储在配置文件中的可执行文件之一的属性。当您更改代码时，配置文件不会更新，但是当您关闭/打开项目时，将从配置文件中提取值，这会将您的更改反转到初始状态！
为了解决这个问题，您需要从配置文件中排除可执行文件（我就是这样做的），或者每次更改包时重新创建配置文件。
我希望这有帮助。
I had the same issue. The reason was that I used a config file with all the executables included, and sql code is just a property of one of the executable which is stored in the config file. When you change your code the config file does NOT get updated, but when you close/open your project the values are getting pulled from the config file which reverse your change to the initial state!
In order to fix this you need either to exclude your executable from the config file (what I did) or re-create the config file every time you change the package.
I hope this helps.
我发现我无法更改发送邮件任务中的“收件人”。或者更确切地说，我会在新值上按“确定”，然后再次调出它，这将是旧值。我所做的是通过搜索旧值并更改它来编辑记事本中的 dtsx 文件。
I found I was unable to change the "To" in the Send Mail Task. Or rather, I would press OK on the new value and then bring it up again and it would be the old value. What I did -- was to edit the dtsx file in Notepad by searching for the old value and changing it.