k_kasa78 (5/1/2015)

---

1.In SSIS 2012 we have option. Below link as good info.

http://www.mssqltips.com/sqlservertip/3013/introduction-to-the-dimension-processing-destination-in-ssis-2012/

2.For XMLA processing and SSIS 2008 . follow below steps

2.1Build XMLA script using script Task Editor - Substitue Dimension Name Process Type

some code snippet as below

Dim xmla As String

xmla = "<Batch xmlns='http://schemas.microsoft.com/analysisservices/2003/engine'>"

xmla = String.Concat(xmla, "<ErrorConfiguration xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:ddl2='http://schemas.microsoft.com/analysisservices/2003/engine/2' xmlns:ddl2_2='http://schemas.microsoft.com/analysisservices/2003/engine/2/2'>")

xmla = String.Concat(xmla, "<KeyNotFound>IgnoreError</KeyNotFound>")

xmla = String.Concat(xmla, "</ErrorConfiguration>")

xmla = String.Concat(xmla, "<Process xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:ddl2='http://schemas.microsoft.com/analysisservices/2003/engine/2' xmlns:ddl2_2='http://schemas.microsoft.com/analysisservices/2003/engine/2/2'>")

xmla = String.Concat(xmla, "<DimensionID>###Substitue Dimension Name####</DimensionID>")

xmla = String.Concat(xmla, "<Type>## Substitue Process Type name like Process Add/Update##</Type>")

xmla = String.Concat(xmla, "<WriteBackTableCreation>UseExisting</WriteBackTableCreation>")

xmla = String.Concat(xmla, "</Process>")

xmla = String.Concat(xmla, "</Batch>")

2.2 Use Analysis Services Execute DDL Task

In DDL Tab

source type variable

source - Script task xmla varable

connection - server connection string