Re: Session Variable in DTS
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 Aug 2006 20:47:07 +0100
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:47FC4E37-D92B-4AA8-AFE0-AEFB013808E2@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: How to move local DTS Package file to database server?
- Next by Date: Re: Very large CSV Files
- Previous by thread: Bulk import data - advice sought on options
- Next by thread: Re: SSIS Package Configurations after Deployment
- Index(es):
Relevant Pages
|
