April 26, 2011 at 10:55 am
Hi, I m using expressions in SSIS package. I have to use variables in select statement. But I keep on getting the error Expression cannot be evaluated. Can someone help in right syntax? below is the query I m using
Select
ColA,
ColB,
+"(DT_STR,@[User::VarA])",
+"(DT_STR,@[User::VarDate])",
ColC
From TableA
Thank you
April 26, 2011 at 11:13 am
Andy Leonard has a great blog on this subject. Take a look and come back with more questions if you still have any.
http://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/ssis-expression-language-and-variables.aspx
April 26, 2011 at 12:01 pm
following is the right expression, I have the syntax wrong
"Select
ColA,
ColB,"
+(DT_STR,20,1252)@[User::VarA] + ","
+(DT_STR,20,1252)@[User::VarDate] + ","
ColC
From TableA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy