Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Taariq
Starting Member
1 Post |
 Posted - 2010-04-14 : 03:45:50
|
| Hi there, Currently am using an SSIS package to export data from a database to an excel file. The problem is that when exported via an application, the excel file contains a mixture of both dd/mm/yyyy and mm/dd/yyyy date format. In the query analyzer my SQL return the good format that is only dd/mm/yyyy for all records and even via the SSIS (Business intelligence development studio).Note that my application uses a stored procedure to execute the SSIS package via xp_cmdshell.Note also that it’s not a problem with the regional settings or the excel sheet date column format because these have already been verified.Further information client windows XP and server windows 2003 using MSSQL 2005Thank you in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-14 : 03:48:32
|
| are you making any type convertions inside ssis for date column?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS problem date format