gvamsimba
asked on
SSIS 2008 Datetime Converstion to Excel
Hi, I am exporting some data to excel using SSIS.
I have a datetime field in my sql server 2008 DB showing as '2009-05-27 16:09:00.000'
but after the data is exported to Excel using SSIS the data in the column is showing as '27/05/2009'. in the data converstion task advanced editor, the data type for this column is showing as 'database timestamp[DT_DBTIMESTAMP].
Can anyone please help me on this ?
Many Thanks
'
I have a datetime field in my sql server 2008 DB showing as '2009-05-27 16:09:00.000'
but after the data is exported to Excel using SSIS the data in the column is showing as '27/05/2009'. in the data converstion task advanced editor, the data type for this column is showing as 'database timestamp[DT_DBTIMESTAMP].
Can anyone please help me on this ?
Many Thanks
'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
nice one..
ASKER
Many Thanks