hi,
i am using SQL server 2005, can i use a session variable in DTS package.
i am importing a Text file, i have a field ("USER_ID") in the database table
that which user has imported the file. how can i achive this.
THanks

Do you want to extract this column value from the file?

Do you want to insert the User's name into a column called USER_ID?


If you want to insert the User's name then look at a derived column
transform and look at a system variable named "UserName"



--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"TaHir" <TaHir (AT) discussions (DOT) microsoft.com> wrote