Post reply

DTS to Excel Error

  • May 27, 2003 at 7:35 am

    #105662

    Hi all,

    I am trying to use DTS to export a table to an excel spread sheet however somewhere during the operation, dates are switching fields i.e. startdate to enddate etc. I have tryed the same sproc in QA and it runs and returns with no errors, also, I have ran the preview report in DTS and it returns correctly....Has anyone seen this error? And if so what is the solution. It is random...one time it could be one date the next another...btw we are running 2000 with sp2

    THanks

  • May 29, 2003 at 10:33 am

    #459063

    u may want to check the column mappings i.e the columns to where the data is getting into at the excel end. In the preview itself you can check the cols.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply