I'm going to use the standard package DumpLoad task in order to load a file and to clear the existing data before loading the new data.
I have configured the task directly in the SSIS package with the following options:
- select "Import into cube" radio button
- select "Clear Existing Data" checkbox
- select the dimensions I want to use to determine the scope of clear data. My understanding of this point is that all the combination of the selected dimensions are deleted.
Is it possible to define all these parameters using the SCRIPTMODIFY, especially the list of dimensions use to determine the scope.
thanks for your help,