I have that mostly working. In a Transformation It is working fine.
<%#CMS.GlobalHelper.SessionHelper.GetValue("AdminID")%>
OUTPUTS value 59 Properly.
SQL QUERY TEXT in Custom SQL Datasource Webpart.
EXEC CU_Proc_LogAction {%CurrentUser.UserSettings.ItemsAsFields.MemberNumber%}
Only returns a 1 Ever. No error. But not getting the session value.
SQL DEBUG Shows:
EXEC CU_Proc_LogAction 3400 , 'StmSum', 200053,1