SQL EXPLORER
About Me
Mohamed Faizal
Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G
View my complete profile
Monday, February 17, 2014
use Expression in the variables
Press F4 on variables pane on the selected variable , Then Edit the Expression as
DATEDIFF
(
"mi"
,
@[System::StartTime]
,
GETDATE
())
Then pass these variables as an input parameter in the SQL Task as shown as below.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment