dbTalk Databases Forums  

How can I use DtsGloablavariables value ?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss How can I use DtsGloablavariables value ? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John
 
Posts: n/a

Default How can I use DtsGloablavariables value ? - 06-25-2008 , 06:31 PM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.