Skip to Content
0
Nov 10, 2015 at 09:45 PM

Limit dimension list in DTSX package

31 Views

I was trying to modify an existing package file so the user would only be prompted for the dimensions relevant to the script. The original package had the following line which lists all of the dimension members in the model when the package is run.

PROMPT(SELECT,,,"Message",%DIMS%)

I would normally change it to something like below but I can't get the right dimensions to appear. It only seems to list the time dimension or any of the secure dimensions and ignores every other dimension I've tried. Is that how it works by design or do I have a syntax issue?

PROMPT(SELECT,,,"Message",%DIM1_DIM%%DIM2_DIM%%DIM3_DIM%)

Regards