将 SSIS 添加到现有 SQL Server 实例
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/24127676/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Add SSIS to existing SQL Server instance
提问by Addie
I am trying to add Integration Services an existing SQL Server 2008 instance.
我正在尝试将 Integration Services 添加到现有的 SQL Server 2008 实例。
I went to the SQL Server Installation Center and clicked the option to "New installation or add features to an existing installation." At this point, a file system window pops up. I am asked to browse for SQL Server 2008 R2 Installation Media.
我转到 SQL Server 安装中心并单击“全新安装或向现有安装添加功能”选项。此时，弹出文件系统窗口。我被要求浏览 SQL Server 2008 R2 安装介质。
I tried C:Program Files\MicrosoftSQLServerbut got the error message that it was not accepted as a "valid installation folder." I went deeper into the MicrosoftSQLServer folder and found \SetupBootstrapbut this was not accepted either. It appears that the only way to proceed is to find the Installation Media Folder but I'm not exactly sure what it's asking for.
我尝试了C:Program Files\MicrosoftSQLServer，但收到错误消息，指出它未被接受为“有效安装文件夹”。我深入到 MicrosoftSQLServer 文件夹并找到了\SetupBootstrap但这也没有被接受。似乎唯一的方法是找到安装媒体文件夹，但我不确定它要求什么。
How can I find the Installation Media folder? Alternatively, other methods for adding SSIS to an existing instance of SQL Server 2008 are welcome.
如何找到安装媒体文件夹？或者，欢迎使用其他方法将 SSIS 添加到 SQL Server 2008 的现有实例。
Thanks.
谢谢。
采纳答案by Milica Medic
To add features to an existing instance go to:
要向现有实例添加功能，请转到：
Control Panel -> Add remove programs
Click the SQL Server instance you want to add features to and click Change. Click the Addbutton in the dialog
Browse to the SQL Server installation file (.exe file), and select the Add features to an existing instance of SQL Serveroption.
From the features list select the Integration Servicesand finish the installation.
控制面板 -> 添加删除程序
单击要向其添加功能的 SQL Server 实例，然后单击更改。单击对话框中的添加按钮
浏览到 SQL Server 安装文件（.exe 文件），然后选择将功能添加到 SQL Server 的现有实例选项。
从功能列表中选择集成服务并完成安装。
Find more detailed information you can find here: How to: Add Integration Services to an Existing Instance of SQL Server 2005it applies to SQL Server 2008 also
可以在此处找到更多详细信息：如何：将集成服务添加到 SQL Server 2005 的现有实例它也适用于 SQL Server 2008
Hope this helps
希望这可以帮助
回答by Tanner_Gram
If you've downloaded SQL from the Microsoft site, rename the file to a zip file and then you can extract the files inside to a folder, then choose that one when you "Browse for SQL server Installation Media"
如果您已从 Microsoft 站点下载 SQL，请将文件重命名为 zip 文件，然后您可以将其中的文件解压缩到一个文件夹中，然后在“浏览 SQL 服务器安装介质”时选择该文件夹
SQLEXPRADV_x64_ENU.exe > SQLEXPRADV_x64_ENU.zip
7zip will open it (standard Windows zip doesn't work though)
Extract to something like C:\SQLInstallMedia
You will get folders like 1033_enu_lp, resources, x64 and a bunch of files.
Idea from this article: SQL Server Installation - What is the Installation Media Folder?
这篇文章的想法：SQL Server 安装 - 什么是安装媒体文件夹？
回答by Abhijeet Kelkar
It appears like it looks for a file. But It can take folder. Just go to the folder where SQL Server is stored. Click on the folder name itself, And click OK. It will take it. And you are done!
它看起来像是在寻找一个文件。但它可以带文件夹。只需转到存储 SQL Server 的文件夹即可。单击文件夹名称本身，然后单击确定。它会接受的。你已经完成了！
回答by Ted Krapf
You can do it simply like this:
你可以简单地这样做：
1.) Download the SQL Server installation package (e.g. SQLEXPADV_etc.exe)
1.) 下载SQL Server安装包（如SQLEXPADV_etc.exe）
2.) Run the installation (only up until it's done extracting the files and shows you the Planning/Install/Maintenance/etc menu). Now leave the installer alone
2.) 运行安装（直到完成提取文件并显示规划/安装/维护/等菜单）。现在离开安装程序
3.) Open explorer, browser to C:\, look for the the latest created folder (will be something like this C:\fae78db1ec127d051abf56)
3.) 打开资源管理器，浏览器到 C:\，查找最新创建的文件夹（类似于 C:\fae78db1ec127d051abf56）
4.) All your SQL install files are in there, you can point the Add/Remove Components dialog at this folder.
4.) 您所有的 SQL 安装文件都在那里，您可以将“添加/删除组件”对话框指向此文件夹。
回答by Dave Jemison
How did you originally install SQL Server 2008 (DVD or download)? That's what the program is asking for. If DVD, pop the DVD in the player, then browse to there. If downloaded, you'll need to extract the files into a folder, then browse to that folder.
您最初是如何安装 SQL Server 2008（DVD 或下载）的？这就是程序所要求的。如果是 DVD，则在播放器中弹出 DVD，然后浏览到那里。如果已下载，您需要将文件解压缩到一个文件夹中，然后浏览到该文件夹。
