I want to create an SSIS package to dynamically create fact group
partitions based on values in my date dimension. However, how will this
affect my SSAS project being out of sync with the database on the
server?

Won't Visual Studio yell when it sees the partitions on the server
which were not created manually within VS? I'm assuming there has to be
a way around this...

In article <1146893369.369121.122160 (AT) i39g2000cwa (DOT) googlegroups.com>,
toddkitta (AT) gmail (DOT) com says...
Services 9.0 Database" and Visual Studio will create a project based on
a selected database.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

OK, I thought it might come to that... pretty kludgy if you ask me.

In article <1147091952.696889.24230 (AT) i39g2000cwa (DOT) googlegroups.com>,
toddkitta (AT) gmail (DOT) com says...
definition is either on your workstation or on the server. If it's on
your workstation you synch the two definitions by doing a deploy, if
it's on the server you synch the two definitions by importing the
project.

If you wanted do something like regularly check the database definition
into source control, you could write a few lines of .Net code or a
simple PowerShell script to save an XML/A create script.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

Hi,
If you want to update the BI project to include the partitions you created
with SSIS, then, indeed, you need to use the 'Import Analysis Services 9.0
Database'. Because the BI project is an offline version of the live
database. But you can use Visual Studio not only to design and deploy BI
projects, but to also administer the database live (as Analysis Manager did
in AS2000). It has the same interface, editors, features, just that it works
directly on the live database (File -> Open -> Analysis Services Database).

Adrian Dumitrascu


"Todd" <toddkitta (AT) gmail (DOT) com> wrote