User needs to export the result set from a cube to an excel sheet. I was
hoping to use DTS to accomplish this by adding a DTS execution command as a
cube action and passing dim.curentmember as parameters

1.I needed help on how I could execute the package from a cube action.
2. How DTS can be made to accept parameter values being passed from the cube

thanks very much

--
Message posted via http://www.sqlmonster.com

I would try making the action a command type action ( running an exe)...
Then call
DTSRUN.exe with its parameters

Since you want to include Cube values, simply generate a string concatenated
from everything you need ( you can pass global varaiable values into DTS via
DTSRUN command line parameters.)

Hope this helps

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

"rama via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> wrote