May 2, 2008 at 12:20 pm
I need to install SSIS (missed in the original install) on a machine already running SP2 in production. I assume I just use the original CD and install it -- but then it's not got any service packs or patches applied. How would I go about applying a SP Just to SSIS? I don't want to risk undoing patches from cumulative updates on the rest of the SQL installation.
May 2, 2008 at 12:34 pm
You are going to want to reinstall the SP and all patches anyway. You will probably not want to risk anything not being at the same patch level.
So I guess my point is - who cares if it uninstalls a hotfix on you? You have to re-apply the hotfix anyway.
May 2, 2008 at 12:41 pm
Thanks for the answer. You affirmed what I knew was the case in the past. I was just hoping somebody knew a way to apply service packs to just the subsystem in question.
May 2, 2008 at 11:17 pm
To add- you can install the components separately and when you go through the SP2 setup the second time around, it should already see that SP2 was already applied to the other components. I've done that before with SSRS, so I would imagine it would be the same for SSIS.
May 4, 2008 at 9:57 pm
As Stephen mentioned, you can install Sql Server Integration Services by running the setup once again (from add/remove programs) and choose integration services to install it.
After it is installed you need to apply any service pack. While executing the service pack it will ask for which instance to apply and also it will ask for what components needs to be patched with. You have the option to select the services like database engine, SSIS, SSRS and client tools like SSMS etc..choose SSIS and proceed with the installation.
Also please note that if a component is already applied with SP it will be disabled when you once again run the SP. Only those components that were
not applied earlier with SP will be eligible to be applied with SP..
[font="Verdana"]- Deepak[/font]
May 5, 2008 at 5:59 am
Thanks for the info. I have more confidence that this won't cause problems with the currently installed subsystems.
May 5, 2008 at 10:26 am
My preference always has been INSTALL everything from the very beginning, INSTALL patches/Service Packs regularly on all of them (SQL Server, SSIS, ...) all those that you feel will be required for sure sometimes in future.
Finaly DISABLE the service, that way it wont affect your memory + processor...
paul
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply