October 17, 2011 at 11:51 pm
Hi,
I am attempting to update a variable in a package running in integration services to a text format of the date, which will then be used in a File System task to create a folder for that date.
I can create the variable OK, however I cannot seem to dynamically set the value of that variable as the job executes?
October 19, 2011 at 3:14 am
You need to provide more information. How are you trying to update the variable, for example. Thanks,
October 19, 2011 at 12:46 pm
You need to use a script task to update the value of a variable. Well, you could do an Execute SQL Task too, but you don't need a connection to do it with a script task.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 19, 2011 at 1:01 pm
we need additional detail as to how you want to or how you are trying to update that variable..
CEWII
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply