@[System::UserName] variable in SSIS
I'm executing SSIS package, like a datareader source in a report in SSRS. Everything it's ok. But, I'm using @[System::UserName] variable like a add column to save the user that ran the package.
But it's incredible, when the user execute the report, the system don't save the login that opened the browser, neither the user that run the ssis service or user for ssrs service. This is catching the user that opened session in the host where Sql server was installed.
I need catch the user that run the report, how can i do this?
JULIAN CASTIBLANCO P
MCTS SQL SERVER 2005