'Setting SQL Server Session Context from SSIS Transfer SQL Server Objects Task
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?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|