Expression for date and id

Amudhan Kuppan

8y901

Hi please help me anyone Iam created two column createdbydate and createdbyid using derived column in ssis what is the expression for these two columns

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
Accepted answer
In SSIS ??????
Are you sure that you are going to get the result that you are looking for? the answer i assume will be no, becasue the preson/group/NTUser that is going to run the package will be the user my point is that the user will always be the same.

You must have the the 2 fields set at the SQLTable level
, [iCreateDate] DateTime NOT NULL CONSTRAINT [DF__YourTable__iCreateDate] DEFAULT (GetDate())--- Timestamping the record
and for user name/id use one of the mentioned the DEFAULT value of your [CreatedById]
SELECT USER_NAME() , SUSER_SNAME() , SUSER_NAME() , USER_SID() , SUSER_ID()
Good luck
Shahriar Nikkhah8y ago
oops for got to say the answer that you are looking for

(DT_DATE)(DT_DBDATE) GETDATE()

and
SUBSTRING((DT_WSTR, 4)(GETDATE()), 1, 4)

And
down vote
(DT_WSTR,10)(DT_DBDATE)(GETDATE())

and for user ID use

@[System::UserName]