Why Variable on SSIS couldn't give the value?

Question

Hello Before this question i already ask on Stckoverflow Create Dynamic Path For SSIS Logging with SSIS log provider for Text files

I Follow the suggestions, but my Log File didn't create? why it happens ? is it Logging on SSIS text Log File Connection couldn't changed dynamically? is it only static connection?

Answer 1

i got the answer accordingh to this link : set filepath from database in SSIS variable for logging

IDTSVariables100 varCollection = null;
this.VariableDispenser.LockForRead("User::FilePath");
string XlsFile;

XlsFile = varCollection["User::FilePath"].Value.ToString();

all i need is :

this.VariableDispenser.LockForRead("User::FilePath");