Variable Expression

I have created a Variable in a new SSIS Package. I changed the EvaluateAsExpression property from its default value of False to True. I clicked on the Expression property but it does not prompt me with a Build Button. Any ideas? is there a property that needs to be set under Tools>Options? I can write my expression in the property but it does not allow me to select the build button to design more sophisticated expressions. Any help is much appreciated.
LVL 2
dmlyo150Asked:
Who is Participating?
 
PedroCGDConnect With a Mentor Commented:
from your image you already has SP 2 installed (9.00.3042)

Install SP3 (9.00.4035)
0
 
nmcdermaidCommented:
Does is work as expression when you type one in manually? I would assume its just a BIDS bug
0
 
dmlyo150Author Commented:
Yes, the expressions work when I type one in manually. but I am new to this and really need the expression builder. sorry but what is a BIDS bug?
almost 128K points -what do you have for me HoggZilla? any ideas?

0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
nmcdermaidCommented:
BIDS = Business Intelligence Development Studio
Thats what you are developing your SSIS pacakge in.
I notice it has a few of these idiosyncrocies - windows that won't resize, annoying stuff like that.
 
0
 
PedroCGDCommented:
Tell me what is your goal... give more details!
Regards,
Pedro
www.pedrocgd.blogspot.com
0
 
dmlyo150Author Commented:
my goal is pretty simple: I want to create a User defined Variable and use it to calculate a value, such as a dated file name, FileName_04162009.txt.
0
 
PedroCGDCommented:
You want to generate a variavble with FileName_04162009.txt, correct?
0
 
PedroCGDCommented:
Do you want something like attached image?

Regards,
Pedro
www.pedrocgd.blogspot.com
SSIS-VarAsExpression.JPG
0
 
dmlyo150Author Commented:
that is exactly what I'm looking for -the expression builder -not the expression. the dated files name is just one of many.
0
 
PedroCGDCommented:
ok... need more help?
0
 
dmlyo150Author Commented:
PedroCGD maybe you didn't read my original post, the problem that I'm encountering is that when I change the EvaluateAsExpression property from its default value of False to True. I clicked on the Expression property but it does not prompt me with a Build Button. I can type the expression manually, but I do not get the build button which allows me to display the expression builder.
0
 
PedroCGDCommented:
oohh.... do you have SP2 installed?
regards
Pedro
0
 
dmlyo150Author Commented:
I think its SP1

ssis-ABOUT.JPG
0
 
PedroCGDCommented:
Download and install SP2
0
 
nmcdermaidCommented:
I do have a build button in my editor. Note my version of Visual Studio is different to yours. How you get it to that version, and whether the RTM thing makes a difference.... I don't know.
My version: 8.0.50727.867 (vsvista.050727-8600)(vsvista.050727-8600)
yours: 8.0.50727.42 (vsvista.050727-8600)
 

BIDS.jpg
0
 
dmlyo150Author Commented:
I cannot find a VS '05 SP2 (download) I read somewhere it might not be a client side install.
0
 
dmlyo150Author Commented:
link?
0
 
dmlyo150Author Commented:
SP3 Fixed it for me -thanks for your help.     davlyo
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.