Link to home
Start Free TrialLog in
Avatar of chuang4630
chuang4630

asked on

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?

Avatar of Jason Yousef
Jason Yousef
Flag of United States of America image

Yep, check this article...
http://support.microsoft.com/kb/963070

ASKER CERTIFIED SOLUTION
Avatar of Jason Yousef
Jason Yousef
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Reza Rad
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
Avatar of chuang4630
chuang4630

ASKER

Missing SP1
Great,I hope they add a sort of intelligent to tell uses that !!! to save them the hassle!!
So now you can open the packages or not?!
Yes, I can open the package now. Thanks.