安装 SSIS 包。有点困惑
好吧——这可能是一个愚蠢的问题，但到底是什么？
我创建了一个包含配置和部署清单的 SSIS 包。当我将其复制到服务器并双击它时，包向导返回了一个错误 - 未安装集成服务 - 糟糕。
但是当我通过 SSMS 执行导出数据任务时，我注意到我可以将此任务保存为包。当我设置一个作业时，我注意到我实际上可以选择一个 SSIS 包来安排 - 即使没有安装 SSIS（！？！）这是否意味着我可以只指向我之前的包并安排它？
如果是这样，您是否只需要安装 Integration Services 即可在 SQL Server 中安装包 - 从文件系统运行它们就可以了？
干杯
Ok - this is probably a silly question but what the hell.
I've created a SSIS package with configuration and a deployment manifest. When I copied this over to the server and double clicked it, the Package Wizard returned an error - that Integration Services wasn't installed - bad.
But when I did an export data task via SSMS, I noticed I could save this task as a package. When I set up a job I noticed I could actually select an SSIS package to schedule - even though SSIS is not installed(!?!) Does this mean I could just point to my earlier package and schedule that?
If so, do you only need Integration Services installed in order to install packages within SQL Server - its fine to run them from the file system?
Cheers
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这是一篇关于以编程方式执行包的不同方法的好文章：
http://blogs.msdn .com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx
Here is a good article on different ways to execute a package programmatically:
http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx