SSIS 包保存在哪里? [英] Where are SSIS Packages Saved?

问题描述

我在 SQL Server 2008 Management Studio 的对象资源管理器中右键单击了一个数据库.我转到任务">导入数据"，然后从纯文本文件导入一些数据，并选择将包保存在服务器上.

I right clicked on a Database in the object explorer of SQL Server 2008 Management Studio. I went to Tasks > Import Data, and imported some data from a flat text file, opting to save the package on the server.

现在我该如何进入包来编辑或再次运行它?在 SQL Server Management Studio 中我该去哪里?我已经扩展了所有内容，但找不到它.快把我逼疯了.

Now how the heck do I get to the package to edit or run it again? Where in SQL Server Management Studio do I go? I've expanded everything and I can't find it. It's driving me nuts.

推荐答案

如果您连接到服务器上的 Integration Services 实例(当您在 SQL Server Management Studio 中连接时，数据库引擎"下拉列表中的不同选择)，它们将位于 Stored Packages 下的 MSDB 文件夹下.

If you connect to the Integration Services instance on the server (different choice in the dropdown from "Database Engine" when you connect in SQL Server Management Studio), they'll be under the MSDB folder under Stored Packages.

这篇关于SSIS 包保存在哪里?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！