Stack Overflow
Stack Overflow

Questions tagged [expressionbuilder]

95 questions
2
votes
3 answers

How to change the font size for the Expression Builder in SSIS

When using SQL Server Integration Services, I like to keep things flexible and therefore I keep any hard coded names in variables. This means using the expression builder quite a lot, but the problem is the font size for the actual Expression is way…
Dave Sexton
  • 10,768
  • 3
  • 42
  • 56
1
vote
0 answers

manually re evaluate expressions in asp.net page

We are doing translations with a custom expression builder in our application. The chosen language is saved in the session. The actual translations get loaded in the application cache when it first starts. We are using .NET 3.5/c# the whole thing…
Arikael
  • 1,989
  • 1
  • 23
  • 60
1
vote
1 answer

Azure Data Flow expression : Unable to parse

Context : Inside Azure Data Factory, I have a pipeline which contains a "Foreach" activity. I'm trying to write an expression for its "Items" setting. In the expression builder, I have entered this…
jeancallisti
  • 1,046
  • 1
  • 11
  • 21
1
vote
2 answers

An easy way of running code snippets written in Azure Data Flow script / Expression Builder?

Some context : When you use Azure Data Factory, you can create "Data Flows" which in turn contain graphical logic bricks, which themselves can transform data with an embedded code editor (the "Dataflow expression builder") that lets you execute…
jeancallisti
  • 1,046
  • 1
  • 11
  • 21
1
vote
1 answer

Azure Synapse Mapping Data Flow - Dynamic mapping of column names in derived columns

In a Mapping Data Flow activity, I have a bunch of tables coming from an unprocessed area of a storage account, and I aim to select only some of these columns for the next more-processed-area. In selecting the columns, I need to translate the column…
bonniethebest
  • 11
  • 1
1
vote
2 answers

Data Flow Partition by Column Value Not Writing Unique Column Values to Each Folder

I am reading an SQL DB as source and it outputs the following table. My intention is to use data flow to save each unique type into a data lake folder partition probably named as specific type. I somehow manage to create individual folders but my…
wwnde
  • 26,119
  • 6
  • 18
  • 32
1
vote
1 answer

ConfigurationManager.AppSettings or only AppSettings?

I have question: when I to use <%= ConfigurationManager.AppSettings["xxx"] %> and <%$ AppSettings: xxx %>. Sometimes when I use <%= ConfigurationManager.AppSettings["xxx "] %> a I got the following error: "Server tags cannot contain <% … %>…
user681119
  • 13
  • 2
1
vote
2 answers

SSIS passing paramater in SQL command with ODBC

I am trying to run a variable in an expression builder SQL command for OBDC. The expression looks like this below "SELECT Date(Curdate()) AS 'Load Date', Sum(CASE WHEN pomstatus = 'TBR' AND…
Richard Nguyen
  • 23
  • 2
1
vote
2 answers

Linq Expression with multiple nested properties

I have read through the question, and answer, Dynamic linq expression tree with nested properties. It does seem to be very similar, though a lack of understanding with Expressions is resulting in me not being able to translate the answer to my own…
Darren Wainwright
  • 30,247
  • 21
  • 76
  • 127
1
vote
1 answer

Why can't I escape double quote characters in SSIS Expression Builder?

I am trying to add a condition to a Conditional Split Transformation in SSIS but the double quote character at the start of a string in the condition is throwing an error. Here is my condition: (FirstName != LkUp_FirstName) || ((ISNULL(MiddleName) ?…
user2989759
  • 279
  • 1
  • 4
  • 14
1
vote
1 answer

Expression Builder giving different values for a field in Percent, Fixed and General Number formats

I am using Expression Builder to set the value for a calculated field which is supposed to be a percentage. In Expression Builder, this is my statement be executed Usage: ((([UsedHeight]*[UsedWidth])/([Length]*[Width]))*100) While selecting the…
Dennis Wanyonyi
  • 368
  • 1
  • 5
  • 18
1
vote
0 answers

How to build expression that search items from ObservableCollection case insensitively

I am building expression using ExpressionBuilder to search items from ObservableCollection but that expression search from collection case sensitively.I want to make it case insensitive. How do I make it ? I have my code here : public class…
Dhruv Gohil
  • 503
  • 1
  • 5
  • 13
1
vote
0 answers

Cannot Use/Open Microsoft Access Expression Builder

I am putting together a simply query like I have done many times before in Microsoft Access 2010. I need to use expression builder to make a calculation for one of the query fields. BUT When I try to open or use the expression builder it is grayed…
Jason Brown
  • 11
  • 1
1
vote
1 answer

How to build a LINQ expression with Contains method from IEnumerable?

I'm trying to build a LINQ expression, to filter values from a int property: protected IQueryable Some(IEnumerable ids) { var parameter = Expression.Parameter(typeof(T), "x"); // "Col_id" (int property) var property =…
Shin
  • 664
  • 2
  • 13
  • 30
1
vote
2 answers

ExpressionBuilder return any type of object

The code below works fine for primitive expressions (no surprise there) public class SiteContextExpressionBuilder : ExpressionBuilder { public override CodeExpression GetCodeExpression(BoundPropertyEntry entry, object parsedData,…
Yvo
  • 18,681
  • 11
  • 71
  • 90
1
2
3 4 5 6 7