How to set expressions to the variables set to an existing package in ssis using C#?

See more:

C#

SSIS

I want to pass expressions to the variables set to existing package in ssis using c# programatically for flat file source component.


I am having source(Flat file) mapped to destination (SQL server DB). Source Path is to be dynamically set.


I am able to pass the expressions but needs to pass the expression value evaluated to the source component variable.

What I have tried:

Code is as below:

// Using the CLSID
Executable exExpressionTask = 
pkg.Executables.Add("Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTask, Microsoft.SqlServer.ExpressionTask, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
TaskHost thExpressionTask = exExpressionTask as TaskHost;
ExpressionTask expressionTask = thExpressionTask.InnerObject as ExpressionTask;

// Set the expression.
expressionTask.Expression = @"10>0";

// Get the expression.
string expression = expressionTask.Expression;

// Validate the expression.
string str = expressionTask.ValidateExpression(null);