Copying Dimensions in BIDS

Is it possible to copy a dimension from one solution/project to another. I have a generic time dimension and a few other common dimensions that I would rather just copy from one project to another rather than setting it up entirely from one project to another.

I tried copying the XML file from one project to another, but that did not work because they had different DSV's, and thus different design-time unique names.

any suggestions?

-ClaytonUsing SSMS, you should be able to script out the creation of the dimension and then execute it in the other database. If you are using different DSV (or DS) names, then you will have to modify the script before you execute it on the other system but hopefully that will be easy. At least it is just editing a single file.

_-_-_ Dave