Database Reference
In-Depth Information
6. You can change additional processing settings as you could with SSMS and
SSDT: specify the number of objects to be processed in parallel, whether
they should be processed in a single transaction or not, as well as custom
configuration for dimension key errors. Click on
OK
once you're happy with
your selection of the processing settings.
7. To test the task you have just defined, you can right-click on it and choose
Execute Task
.
Another option for executing processing XMLA commands is to use
Analysis Ser-
vices Execute DDL Task
available under the
Other Tasks
group within the SSIS
toolbox. To process objects using this option, first use SSMS to script the processing
XMLA command you wish to use and save it to a file. To execute this file using SSIS
package, perform the following steps:
Search WWH ::
Custom Search