Any difference between processing via a .dtsx and from within BIDs?

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply