如何删除已部署到文件系统的SSIS包
是否像删除文件一样简单,或者在删除文件之前我必须执行任何操作来取消注册它。
部署过程除了将其复制到“Packages”文件夹之外还执行其他操作吗?
Is it as simple as deleting the file, or do I have to do anything to de-register it before I delete it.
Does the deployment process do anything more than copy it to the "Packages" folder.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
SQL Server 确实在目标 SSIS 服务器上注册 SSIS 包。如果从文件系统中删除包,则会将注册信息保留在 SSIS 服务器上。
从服务器中删除已部署的 SSIS 包的最佳方法是使用 SQL Server Management Studio、对象资源管理器并连接到 SSIS 服务器(请注意,在连接对话框中,您的服务器类型是 Integration Services,而不是 Database Engine。)存储的包>文件系统来查找您的项目。右键单击该项目并选择删除。
顺便说一句,如果您已经从文件系统中删除了文件,则从 SSIS 服务器删除时会出现错误。您可以重新部署 SSIS 包,然后从 SSIS 服务器中删除。
SQL Server does register the SSIS packages on the target SSIS server. If you delete the packages from the file system, you would leave the registration information on the SSIS server.
The best way to remove a deployed SSIS package from a server is to use SQL Server Management Studio, Object Explorer and connect to the SSIS server (note that your server type is Integration Services, not Database Engine, in the connection dialog.) Navigate to Stored Packages > File System to find your project. Right-click the project and select Delete.
By the way, if you already deleted the files from the file system, you'll get errors when deleting from the SSIS server. You can redeploy the SSIS packages and then delete from the SSIS server.