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