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

Any difference between processing via a .dtsx and from within BIDs? Expand / Collapse
Author
Message
Posted Wednesday, June 5, 2013 8:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 3:13 AM
Points: 19, Visits: 73
Can I be 100% sure that when Processing my cube from within SSAS(BIDS) will have the same processing done via a .dtsx?

The DTSx has Process Option to "Process Full", order in Sequential, All-in-One transaction Mode.

On two separate occasions I have felt that the dimensions aren't getting processed when done via DTSx, but when I process it manually from BIDs
it's showing all the values in the DIM I need.

Hence my doubt of having any difference in both.

Also how do I create a log file of Errors when processing via batch/dtsx file? I want to see any errors in the weekly processing of Cubes.
dtexec /Rep E /f "C:\Cubes\refresh_cubes.dtsx"

Many Thanks for the help.
Bij
Post #1460251
Posted Wednesday, June 5, 2013 8:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:12 PM
Points: 3, Visits: 94
You can go into SSMS and check the Property of the DIM / FACT and get the time of last process.

The PROCESS FULL and other PROCESS functiona do the same type of processing, but FULL processes ALL (whether needed or not) and the other items handle other functions:
http://blogs.msdn.com/b/karang/archive/2011/01/25/kind-of-ssas-processing-in-simple-words.aspx?Redirected=true


Seems to be a good article on the differences
Post #1460252
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse