Processing Cube, setting Connection String via Expression

• Tobias Kiemes

  SSCommitted

  Points: 1604

  More actions

  November 25, 2009 at 9:40 am

  #385851

  Hi,

  in my ssis package I am processing Dimensions and Cubes. The package has a variable, in which I store the SSAS connection string. The SSAS Connection Manager has an Expression in which I set the value from the variable.

  This way worked fine in the relational word. Now, with ssas it looks like the package ignores the expression. It always processes the cube on the database I developed the package with.

  Is this a bug?

  Thank you,

  Tobe

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  November 27, 2009 at 4:01 am

  #1084842

  It works fine for SSAS as well.

  You can add connection string variable in package configuration file. Connection Manager will pick whatever the Server name defined in config file.

  I have more than 50 cubes and it worked fine for me.

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers