Hi, I have select statement in my dts package and it returns 2-3 rows for DtsGlobalVariable. So I am vbscript stuff to catch that value and use it to create a new partition for cube. So example how can move my global variable's value to a variable newpartition = DtdGlobalVariable("xxx_name").value doesnt work and it gives type mismatch error but it is string thanks John
