View Single Post
  #1 (permalink)  
Old September 18th, 2010, 12:39 PM
VBUser26 VBUser26 is offline
Registered User
 
Join Date: Sep 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Setting a Global Variable value help

I have a dts that uses a global variable that is used in the dynamic properties and has a value of a file location and filename. The variable is set using a query which adds the file location and filename and also current day and month to the end ie

\\directory\folder\filename.filetype + current day-month

I need to change the value of the global variable when my dts gets to a specific process. I have an activex script that changes the value (file location and filename) and this work fine but i cant same to get the code to add the current day and month to the end, how do i concatenate the global variable value with the the current day and month added on at the end?