• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

How to open and edit the SSIS in VI Studio 2008?

I am trying to open and edit a SSIS package. The guy who developed this has left so I have to turn to this forum.

Of course, I make sure it is opened in BID 2008. The windows keeps giving me the error message like this:

.... Integration service has to be installed by one of these editions of SQL Server 2008: ....... To install Integration Services, run SQL Server Setup and select Integration Services.

I do have the SSIS installed by looking at Windows--> AllApplications--> SQL 2008 --> Integration Servive folder. I also make sure it is turned on by checking the Control Panel--? Applications and features.

Is there anything I missed?

0
chuang4630
Asked:
chuang4630
  • 4
  • 2
1 Solution
 
Jason Yousef, MSSr. BI DeveloperCommented:
Yep, check this article...
http://support.microsoft.com/kb/963070

0
 
Jason Yousef, MSSr. BI DeveloperCommented:
Also just make sure the SSIS service is running, I know it gives different error but just check it..
 services.msc
0
 
Reza RadCommented:
what happened after installing SSIS? did you got any other error?
to install SSIS: in the SQL Server integration service you should select the Integration services
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
chuang4630Author Commented:
Missing SP1
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
Great,I hope they add a sort of intelligent to tell uses that !!! to save them the hassle!!
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
So now you can open the packages or not?!
0
 
chuang4630Author Commented:
Yes, I can open the package now. Thanks.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now