June 26, 2012 at 11:27 pm
Hello friends,
Can I add Integration Services to an Existing Instance of SQL Server 2005 while its in use. I dont want to have to schedule a down-time of the server if i dont need to.
Cheers,
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
June 27, 2012 at 1:31 pm
If it were me I would not take the advice of anyone on a forum for this one. If you have a dev environment, try it there first and find out for yourself.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2012 at 12:47 am
opc.three (6/27/2012)
If it were me I would not take the advice of anyone on a forum for this one. If you have a dev environment, try it there first and find out for yourself.
+1
I would think you don't have to restart the database engine, as the SSIS service only monitors folders and package executions, but don't take my word on it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 4, 2012 at 5:21 pm
For the record and to those who are interested.
You can installed SSIS components to SQL without interupting the normal service.
Cheers 😎
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
July 6, 2012 at 12:04 am
Mr J (7/4/2012)
For the record and to those who are interested.You can installed SSIS components to SQL without interupting the normal service.
Cheers 😎
Good to know. Thanks for posting back.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply