shrsan (5/21/2013)
Thanks SSCrazy...But i want an expression to write in the derived column of ssis.Am adding Timestamp Column from derived column into the table.
Do u have an expression fro derived column?? right now am just using getdate()
Based on DATEPART and DATEADD for SSIS in MSDN the following is what you want to use in an expression in SSIS:
DATEADD("Ms", -1 * DATEPART("Ms", GETDATE()), GETDATE())
Not having worked with SSIS for several years, I will leave it to you to determine exactly how this expression should be written to accomplish the task you are working on using a derived column in SSIS.