Is this possible to have done in 2 different (or 1 intelligent) AS deployment script(s)? Sunday would be the full processing day, while other days would just handle the smaller fact areas.
You could use Integration Services with XMLA scripts to accomplish this...
Frank
|||Is this type of thing something that's available in standard edition? I tried making a new connection with type of Integration Services, but I'm not sure where to go from there, as the object exlorer appears to give no options to make a new package or whatever route I'd need to take to make a new schedule.
Could you provide more info as to how it would be created and then scheduled (or is this a manual thing if not an option provided by SSIS)?
|||Yes, this is available in the standard edition.
how to create an SSIS package: http://msdn2.microsoft.com/en-us/library/ms141178.aspx
This thread explains a couple of different ways to do this: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1626707&SiteID=1
Frank|||I will take a look over the article. Thanks.
I also want to ask again, is it possible to process all fact tables but one (not by specifying the name of the facts, but only the name of the one I don't want to process)?
No comments:
Post a Comment