SQL Server 代理错误 - 连接“DatabaseName”没有找到吗？
对 SSIS 包进行了一些修改，我似乎无法弄清楚出了什么问题。涉及执行其中一个包的 SQL Server 代理作业直到几天前都运行良好。我看到的错误是这样的......
以用户身份执行：域名\serviceaccount。 ... 32 位版权所有 (C) Microsoft Corp 1984-2005。版权所有。开始时间: 4:47:33 PM 错误: 2010-07-07 16:47:34.09 代码: 0xC001000E 来源: PackageNAME 描述: 未找到连接“DB.NAME”。当找不到特定的连接元素时，Connections 集合会抛出此错误。结束错误警告：2010-07-07 16:47:34.09 代码：0x8001F02F 来源：PackageNAME 说明：无法解析包“.Connections[DB.NAME].Properties[ConnectionString]”中对象的包路径。验证包路径是否有效。结束警告 警告：2010-07-07 16:47:34.09 代码：0x80012017 源：PackageNAME 描述：包路径引用了无法找到的对象：“\Package.Connections[DB.NAME].Properties[ConnectionString]”。当尝试解析包时会发生这种情况...包执行成功...该步骤成功。
我没有收到任何有关作业出现错误的警报，因为正如最后一行所示，该步骤成功了。因此，这项工作有几天没有“正常”运行，我正在摸不着头脑，不知道可能出了什么问题。以前有人见过这个错误吗？
Some modifications were made to an SSIS package and I can't seem to figure out what is wrong. The SQL server agent job which involves execution of one of these packages was running fine until a couple of days ago. The error I am seeing is this...
Executed as user: domainname\serviceaccount. ... for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:47:33 PM Error: 2010-07-07 16:47:34.09 Code: 0xC001000E Source: PackageNAME Description: The connection "DB.NAME" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Warning: 2010-07-07 16:47:34.09 Code: 0x8001F02F Source: PackageNAME Description: Cannot resolve a package path to an object in the package ".Connections[DB.NAME].Properties[ConnectionString]". Verify that the package path is valid. End Warning Warning: 2010-07-07 16:47:34.09 Code: 0x80012017 Source: PackageNAME Description: The package path referenced an object that cannot be found: "\Package.Connections[DB.NAME].Properties[ConnectionString]". This occurs when an attempt is made to resolve a package ... The package executed successf... The step succeeded.
I did not get any alerts that the job had an error because as the last line suggested, the step succeeded. Because of this, the job did not run "properly" for a few days and I'm scratching my head as to what may be the problem. Has anyone seen this error before?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
dts 作业步骤具有与 SSIS 包关联的变量和变量值。在 SQL 2008 中，SQL 代理、作业、作业、步骤、作业步骤属性。有一组选项卡。每个都会影响包的运行方式。例如，“数据源”选项卡允许您更改任何数据源的连接字符串。这里有一个猜测 - 有一个名为“DB.NAME”的连接，它是在作业中定义的，但不在 SSIS 包中定义。
无论如何，如果您进行了重大更改，请尝试从 SSIS 包重新创建作业，看看这是否不能解决您的问题。
The dts job step has variables and variable values it associates with the SSIS package. In SQL 2008, SQL Agent, Jobs, Job, Steps, Job Step Properties. There are a set of tabs. Each has influence on how the package runs. For instance, the Data Sources tab allows you to change the connection string to any of your data sources. Here's one guess - there's a connection named "DB.NAME" which is defined in the job, but not in the SSIS package.
Anyways, if you made significant changes, try recreating the job from the SSIS package and see if that doesn't solve your problem.