Hi There, Im getting a date field from sql server database to Excel so in my select query i've converted to my desired format MM/DD/YYYY and because of unicode convertion errors i have used DATA CONVERTION Task inbetween and then to EXCEL Destination Now the problem is i am not getting excatly the same format what my select query fetchs from database My Select Query : SELECT CONVERT(varchar(10), Colume_Name, 101) AS Data_Dt from Table From that query i get the format desired : MM/DD/YYYY Now after Data Convertion im getting this kind of format : 2011-04-30 00:00:00 Desired Results : 4/30/2011 Any help ? Thanks

Hello, After your query , if you will bring the Excel Destination, Then create connection and then in Table , Select NEW, IT will bring Create Script for your Excel sheet depending upon your input query, There You can make a change for Date Column to NVARCHAR(255) , Finally map them. This way you will be exporting your date as Text and Format will not change. Thankshttp://sqlage.blogspot.com/

Worked !! Thanks Aamir :)