Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Unanswered: SSIS Date format problem

    Hi

    I have a big problem with an SSIS package. First of all its 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

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    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


    StePhan McKillen
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •