August 28, 2006 at 5:39 am
Got a procedureal problem with Analysis Services database names. The project people want the database names to be different between production, test and development. (ProdDB, TestDB, DevDB, etc...). I have to write SSIS packages to process the dimension and cube objects. I'm looking for a configuration method that will allow me to alias the database name and code to it. It seems that there should be some way to use a ".config" entry, but I couldn't make it work or find documentation that talks about how to do it.
Any ideas?
August 28, 2006 at 12:19 pm
Figured it out. I was trying so hard to use config files that I didn't look at using variables with expressions. If you declare package variables, use expressions to assign them to connection values for server and database names, then supply the values when you call the package, you're done. Thanks anyway.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply