title: Setting SQL Server Session Context from SSIS Transfer SQL Server Objects Task
body: <p>I need to run a SSIS Transfer SQL Server Objects Task under a SQL Server session context.  A function provides a default value for tenant id column that is obtained from the session context.  I cannot find a way to set the session context so that it is available to the task.  Is this even possible?</p>