为什么我的 SSIS 配置更新未保存？
我有一个 SSIS 2005 包，它已在我们的生产环境中启动并运行。 该软件包使用 SMTP 连接管理器将电子邮件消息发送给指定用户。 我们有一个执行此包的预定作业，并且还覆盖 SMTP 连接字符串，以便该包可以针对测试或生产邮件服务器，这使得可以在我们的测试和生产服务器上保留单个服务，只是配置不同。
我们最近更改了生产邮件服务器的服务器名称，并进入计划作业并更改了运行的命令提示符值以指向新服务器。 但是，第二天早上该作业失败，错误日志表明该作业尝试连接到旧邮件服务器。
我在更新 SSIS 包参数时缺少什么吗？ 我是否必须删除现有包，然后重新导入并重新安排作业才能保留新的服务器更改？
I have a SSIS 2005 package that is up and running in our production environment. The package uses an SMTP Connection Manager to send an e-mail message out to a designated user. We have a scheduled job that executes this package, and also overrides the SMTP connection string so that the package can target the test or production mail server, which makes it possible to keep a single service on both our test and production servers, just configured differently.
We recently changed the server name of our production mail server and went into the scheduled job and changed the command prompt values that run to point to the new server. However, the next morning the job failed and the error log indicated that the job tried to connect to the old mail server.
Is there something I'm missing to updating the SSIS package parameters? Do I have to delete the existing package, and then reimport and reschedule the job again in order for the new server change to hold?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我工作的地方的 dba 也有类似的问题。 他们必须更改作业的运行参数，但似乎使用修改后的参数运行作业只有在第一次运行时才有效。 在那次运行之后，它在后续运行中继续使用旧值。 他们必须重新包装这该死的东西。
The dba's from where I work had a similar issue. They had to change a job's running parameters, but it seems like running the job with modified parameters only worked the first time they ran it. After that run, it kept using the old values in subsequent runs. They had to repackage the damned thing.
如果您正在使用包配置功能？ 它可以对执行顺序很挑剔。 这里有更多信息： http://msdn.microsoft.com/en-我们/library/ms141132.aspx
If you are using the package configuration feature? It can be picky on the order of execution. There's some more info here: http://msdn.microsoft.com/en-us/library/ms141132.aspx