September 28, 2007 at 2:40 pm
Currently, I used the following code below in the expression builder
"Executed at " + (DT_WSTR, 30) @[System::StartTime]+"
"+
"Ended at " + (DT_WSTR, 30)GETDATE()
But the results came in two different formats.
Executed at 9/28/2007 4:27:43 PM
Ended at 2007-09-28 16:38:47.138000000
Is there a way to have them in a same format?
September 28, 2007 at 10:28 pm
Have you tried adding one more cast as date to the startdatetime variable?
September 29, 2007 at 12:45 pm
It doesn't take SQL functions in the expression builder, does it?
September 29, 2007 at 12:48 pm
Got me there. I have barely just enough experience with SSIS to spell it. I was hoping it would give you some inspiration, but apparently not.
I'll leave this one for other DBAs.
Good luck with this.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply