Cannot view SSIS Package in Solition Explorer

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.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

Cannot view SSIS Package in Solition Explorer

Author

Topic

katusha
Starting Member

5 Posts

Posted - 2009-02-24 : 10:14:45

When I select SSIS Package in Solution Explorer and select View Designer, the following error is displayed:
To design Integration Services packages in Business Intelligence Development Studio, Integration Services has to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services.

I went to the SQL Server Installation Center to add features to an existing SQL Server 2008 instance and It prompted for SQL Server 2008 Installation Media. I have selected path that SQL Server currently installed.
and got message is not a valid installation folder: C:\Program Files\Microsoft SQL Server. I have also tried to run setup and did not find Integration Services feature.
I am using SQL Server 2008 on Windows Vista.
Has anybody come across this issue?

Thanks,

heavymind
Posting Yak Master

115 Posts

Posted - 2009-02-26 : 05:28:27

what is the result of select @@version for your instance?

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

katusha
Starting Member

5 Posts

Posted - 2009-02-26 : 11:45:28

SQL Server 9.00.3077.00 - SP2 (Express Edition)

heavymind
Posting Yak Master

115 Posts

Posted - 2009-02-26 : 12:28:59

so you have Express Edition. the error message
Integration Services has to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. should make sense

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

katusha
Starting Member

5 Posts

Posted - 2009-03-02 : 14:24:13

It looks like I have not been able to intall
Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for Developers or for IT Professionals. I have the following OS on my machine
Windows Vista Enterprise 2008, Service Pack1.
Has anybody come across this issue?

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources