Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cshekar
Starting Member
49 Posts |
 Posted - 2004-10-01 : 13:58:45
|
I have created one DTS packge to load Excel file to my SQL Serevr Table but I wanted update user column using SYSTEM_USERwith in DTS,but each time when this DTS executed it loads the fiel to my table but it fills the user as only my name is it because I am teh creatror of thet his DTS.could some body help me how to update table with current users chandra shekar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-01 : 14:23:00
|
| Which current users? From sp_who?Tara |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-10-01 : 14:28:07
|
| I would suspect it would get the SQLAgent service account (Assuming the package is scheduled). What user do you expect it to get?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
cshekar
Starting Member
49 Posts |
Posted - 2004-10-01 : 15:15:56
|
| I wanted to update user name who ever loded or excel file from web application, this DTS package executed fron Stored proc and that stored proc executed through the web asp.I mean is who ever loaded the file from web that user name I wanted to update as system user in teh table, every user has SQL authentication before they go to web to upload file but I am using System_user with my DTS to update my tableregardless of whoever execute the package it will user as me only that means I created teh package...chandra shekar |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-01 : 15:17:56
|
| I don't think this is possible unless you pass in the username to the stored procedure.Tara |
|
|
|
cshekar
Starting Member
49 Posts |
Posted - 2004-10-01 : 16:30:29
|
| Thank you so much I think that is the only way to pass user name to proc.chandra shekar |
|
|
|
|
|
|
How to Update current USER