I will Try on That!!

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??...

Hey,

Am trying to add an timestamp column by using derived column but i dont want to get the milliseconds. i tried using the expression which is mentioned above but am...

I used this expression as mentioned in one of the post but it dint work for me.

""If you set the derived column error output to "Ignore Failure" on truncation then...

Sorry about that!

I need an expression to write in derived column transformation to get the data and time but time only till seconds i dont need milliseconds.

Thank you soo much Brahma.... i have been trying it from 2days i just have to add(""):-)

finally...Once again thanks

I am also looking for the same...Please Help..

I dont understand that website ...can anyone guide?

sorry i used this "\t"

yes i tried it by using expression replace([column 0],"/t"," ") dint work.

Thanks