Hi All I have seen several posts on this issue but as yet no answer. So i'm hoping that somewhere out there knows what the issue is. SSIS package queries database creates MS spreadsheets per customer and then emails each customer their list. Anyway all works fine apart from the fact that the Excel Destination Editor converts the date from uk to us format. My routine is already using an MS Excel template (correctly formatted) which it copies as part of the package. Any ideas anyone? rgds

If the excel is used to look at the data you could export the field as text field. Also look at the date format in SQL ( is it UK english for the database and the user account )

Thanks for the quick reply Alun, I tried to change the data type to Unicode text Stream[DT_NTEXT] but i throws an error I have made my format in my select query what ever the format was, but why is it not going as it is as coded ? It is not a UK English for database, its US English

Excel isn't a database, and doesn't respect any data typing you give it. You may very well be sending it date data - but remember that date types don't have any "format". Only when they're converted to strings to they assume a "format". It's Excel, and Excel alone that's deciding to reformat your data on you - and SSIS has no mechanism to set the date format in an Excel cell in the Data Flow. Your only choices are to use a pre-formatted template worksheet to insert rows into, or to use a Script Task to modify the Excel sheet with the Excel COM API after you've put data in it. Talk to me now on

Two thing you could try : 1, Convert Date format as you wish from Query string Ex: SELECT CONVERT(varchar(10), mycolumn_name, 101) AS whatever_ColumnName from Table 2, in Excel Destination Click on New in "Name fo the Excel Sheet" then change the data type of that field to NVARCHAR or what ever is required. Should work !! Thanks