I am trying to use a package configuration that I have stored in SQLServer for my connection string to an Analysis Services database. When I execute the package, it appears to be replacing my connection string in the package with an empty string (see excerpt from logging below). Using XML for this configuration works fine, but that is not consistent with how we are managing all of our database connections, so I'd rather not start down that path. Log file excerpts: Information: The package is attempting to configure from SQL Server using the configuration string "<database>";"<config table>";"conn_aletheia". [Connections] Information: aletheia has a connection string of "". [Analysis Services Process Task] Error: The connection string is not valid. Here is the configuration as stored in SQL Server: TIA, Chad

Hi, May I know which connection you are using in your SSIS package? Is it analysis services connection 9.0 or 10.0? Also are you mentioning the Initial Catelog i.e Analysis services database name in config file? If you define the database name it should execute without any issues. Please let me know if you still having the same issue. Thanks, Vaibhav

Thanks for the response Vaibhav. It is 10.0. Specifically, MSOLAP.4. Yes, the Initial Catalog is in the config string that is stored in SQL Server. I am still having the same issue. As I said, it is only when I store the configuration in SQL Server...it works fine when stored as an XML file configuration.

Hi SQLSavant, Sorry for replying late. If you can handle the logic through SSIS script task then you should not be facing any issues. You can just give a try to this approach. If you give me the details of your package it would be helpful for me to suggest you possible approaches. Thanks, Vaibhav

Hi SQLSavant, Please refer to the following links, and then check if it works for you. SSIS Package Configurations using SQL Server table...an alternative to the Indirect method: http://www.rafael-salas.com/2007/01/ssis-package-configurations-using-sql.html Understanding Integration Services Package Configurations: http://msdn.microsoft.com/en-us/library/cc895212.aspx Hope that helps! Thanks, Eileen

I went with the XML config file approach. Once I get some time, I'd like to revisit this and try some other options. Thanks! Chad