I have a big problem with an SSIS package. First of all it’s running on a windows server 2003, SQL server 2005 and Office 2003. The package is responsible for exporting data from a database to an excel sheet. There is a field date which has been converted in the format DD/MM/YYYY in the SQL. When I test the query in SQL server I got the right date format and also when I run the package via the SQL server business intelligent development studio.
However my problem is that when it is executed via xp_cmdshell in a stored procedure (called by an application), in the same Excel sheet I got date for some records in the format DD/MM/YYYY and other records MM/DD/YYYY.
Can such thing be resolved? Is there is bug somwhere
Please help its urgent
the only way I fix this problem was to format the date to dd - MMM - YYYY
make the month the month name excel will still see it as a date value
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.