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 managed to get some info on the dtsrun utility. But I need to have the
DTS target file - excel sheet - to be defined by the user. How can I do
that?

thanks

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