Unable to use VariableInput in OleDbSource

I'm trying to create a data flow component with an OleDbSource using a variable as a query source.
I know for a fact that the variables end up being created because if I use direct input instead as a test, they show up in the variables panel.

I'm getting the following error:

Error    20   
Could not resolve reference to '@[User::EMPLOYMENT_SelectStatement]' in property 'Variable'. '' is invalid. Provide valid scoped name. Property Variable.

<Variables>
    <#
    // ##### For each table to replicate, create a variable that contains the select statement#####
    foreach(DataRow tableReplicate in tableReplicateList.Rows)
    {
        string tableSourceSystemName = Util.ConvertFromDBVal<string>(tableReplicate[0]);
        string tablePackageGroupName = Util.ConvertFromDBVal<string>(tableReplicate[12]);
        if (!tableSourceSystemName.Equals(sourceSystemName) || !tablePackageGroupName.Equals(packageGroupName))
        {
            continue;
        }  
        #>
        <Variable Name="<#=Util.ConvertFromDBVal<string>(tableReplicate[5])#>_SelectStatement" DataType="String" IncludeInDebugDump="Exclude" EvaluateAsExpression="true">
            <#=Util.ConvertFromDBVal<string>(tableReplicate[10])#>
        </Variable>
        <Variable Name="<#=Util.ConvertFromDBVal<string>(tableReplicate[5])#>_LastLoadTS" DataType="String" IncludeInDebugDump="Exclude">
            1999-01-01 12:00:00
        </Variable>
    <#
    }
    #>
</Variables>


<OleDbSource Name="Select <#=Util.GetDisplaySourceTableName(tableReplicate)#>" ConnectionName="SQL Kronos">
    <VariableInput VariableName="@[User::<#=Util.ConvertFromDBVal<string>(tableReplicate[5])#>_SelectStatement]"/>
</OleDbSource>

Great article with a wealth of valuable insights! It’s like navigating the tricky scenarios of Bad Parenting, the online game where managing chaos is half the fun. Just like the detailed explanations here, Bad Parenting challenges your quick thinking and multitasking skills in the quirkiest way possible.