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.