Create a SSAS CLR Assembly Programmatically

Question

Is there a way to create an assemblly on SSAS programmatically through a command that could be executed from the ASCMD.EXE utility instead of doing that manually from SSMS or BIDS?

Thanks

---

Luai7

Answer 1

Hi Luai,

Yes, please refer to http://msdn.microsoft.com/en-us/library/ms175340(v=sql.90).aspx on how to do it.

Regards,
Jerry

TechNet Subscriber Support in forum
If you have any feedback on our support, please contact  [e-mail]

Answer 2

Thanks Jerry,

How do you fill-in the below section:  ??!!

 <Data>
                  <Block>binarydatablock</Block>
                  <Block>binarydatablock</Block>
                  ...
</Data>

---

Luai7

Answer 3

Found the answer :-)

From SSMS on your development server, open the create new assembly wizard from Assemblies > New Assembly... , select the assembly dll file and enter the impersonation information, then click the Script button at the top-left of the screen in order to store this in an XMLA script file.

Later on you can take this XMLA script file and execute it against the production server through ASCMD.EXE

Note: To set up a password for the impersonation, you need to manually  add the section:

<Password>MyPass</Password>

inside the XMLA file just below the account name section. However, make sure to dispose or hide the XMLA file afterwards to avoid someone getting the password... :-)

---

Luai7