新服务器上的子 SSIS 包出现随机 0x80004003 无效指针错误
我们有一个新的 SQL 2008 R2 实例，它是 Windows 2008 上集群（主动/被动）的一部分。我正在 SQL 实例上测试一个调用许多子包的 SSIS 包。它在随机包上崩溃（很少有两次相同），并出现以下错误：
准备加载包时出现错误 0x80004003。无效指针。
我可以从 SSIS 包存储中运行单独的包。我还可以从 BIDS 运行主包，它会完美运行。
我尝试过修复 SQL 实例，但没有任何区别。我还尝试删除所有包并将其重新导入到 SSIS 包存储区，但没有任何更改。我的 google-fu 很弱，因为我在云中找不到任何有用的东西。
SQL 服务器错误日志或任何 Windows 错误日志中都没有任何内容。
有人有什么想法吗？
We have a new SQL 2008 R2 instance that's part of a cluster (active/passive) on Windows 2008. I'm testing an SSIS package on the SQL instance that calls many child packages. It's been dying on random packages (rarely the same one twice) with the following error:
Error 0x80004003 while preparing to load the package. Invalid pointer.
I can run the individual package from the SSIS package store just fine. I can also run the master package from BIDS and it'll run perfectly.
I've tried a repair on the SQL instance but there was no difference. I also tried removing and reimporting all the packages to the SSIS package store, with no change. My google-fu is weak, because I can't find anything useful in the cloud.
Nothing is in either the SQL server error logs or any Windows error logs.
Anyone have any ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我有同样的问题。
我关闭了视觉工作室并以管理员身份重新启动它（Shift + 使用鼠标右键单击），它对我来说工作得很好。
I have the same issue.
I closed the visual studio and restart it as an administrator (Shift + Right Click using the Mouse) and it worked fine with me.
对我有用的是改变包装上的保护级别。我将父包和所有子包的保护级别设置为 DontSaveSensitive，然后重新部署。不再收到错误。
希望这对某人有帮助。
What worked for me was chaging the protection level on the packages. I set the protection level on the parent and all the child packages to DontSaveSensitive, and re-deployed. No longer received the errors.
Hope this helps someone.
从头开始重建主包解决了这个问题。不过，如果有人有想法，我很想听听；在美好的一天重建它是一件痛苦的事。
Rebuilding the master package from the ground up fixed the issue. Still, if someone has an idea, I'd love to hear it; rebuilding it is a pain on a good day.
我面临着同样的问题。我使用执行包实用程序 (EPU) 来运行从 BIDS 2008 创建的父包。不知何故，
在加载包时它给了我错误 Error 0x80004003。无效指针。
问题是有两个 SQL Server，2008 R2 和 2012。默认情况下，“EPU”从 SQL Server 2012 运行，但失败，因为包是从 BIDS 2008 创建的。您必须从成功执行包的 SQL Server 2008 文件夹运行 EPU。
我希望这对你有帮助。
I was facing same problem. I used Execute package Utility (EPU) to run Parent package created from BIDS 2008. somehow It gave me error
Error 0x80004003 while loading the package. Invalid pointer.
The issue was having two SQL Server, 2008 R2 and 2012. By default, "EPU" run from SQL Server 2012 which is failed because package created from BIDS 2008. You have to run EPU from SQL Server 2008 folder which execute package successfully.
I hope this help you.