Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2011-09-12 : 12:05:57
|
| I have a complete Installation of SQL 2005 Std Edition on my server including SSIS, SSRS & SSAS.I would like to install only SQL 2008 SSIS Service.When executing setup.exe for SQL 2008 installation, what are the options that I should pick 'Install new instance' or 'Add features to existing instance' ?What feature will I select to only have SSIS installed, no SQL 2008 BIDS is required, since this is the server ?I tried searching online and was hoping to find installation steps with screen shots, but couldnt find any.Kindly advise. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-12 : 13:16:37
|
| select only integration services and exclude desktop components------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-09-12 : 15:30:26
|
| SSIS is a shared component. I think you cannot install new instance of ssis when ssis is already installed as shared component in 2005. Only option available is to upgrade shared components to 2008. |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2011-09-12 : 17:15:24
|
| Thanks Visakh, that worked just fine. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-13 : 00:11:07
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Install only SQL 2008 SSIS