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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
to install SSIS: in the SQL Server integration service you should select the Integration services
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?!
ASKER
Yes, I can open the package now. Thanks.
http://support.microsoft.com/kb/963070