Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Missing BIDS package Expand / Collapse
Author
Message
Posted Thursday, August 28, 2014 9:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:47 AM
Points: 65, Visits: 259
I am running SQL Server 2008, and have recently been handed over all the SSAS packages to manage.
I have one package I can see and process when I connect to Analysis Server in SSMS, but I cannot find the actual package to open BIDS. Our process is to store all production SSAS solutions in one place - however this one is missing from the folder. It runs and processes when connecting to the Analysis Server in Management Studio, but we need to access the actual BIDS package to edit it.

Can someone someone tell me if there is a way to find the actual BIDS package using the information in SSMS? Thanks!!
Post #1608326
Posted Friday, August 29, 2014 4:39 AM This worked for the OP Answer marked as solution
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:16 AM
Points: 543, Visits: 1,048
In BIDS if you go to New Project, in the analysis services menu you have an option to Import from Server. This will create a BIDS package from your SSAS database after going through a short wizard. You can then save this package wherever you want. If you lose it again, repeat the process




I'm on LinkedIn
Post #1608540
Posted Friday, August 29, 2014 7:49 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:47 AM
Points: 65, Visits: 259
Nice! And it was right there in front of me the whole time. Thanks so much for the assistance!
Post #1608603
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse