June 5, 2013 at 8:20 am
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
June 5, 2013 at 8:26 am
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:
Seems to be a good article on the differences
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply