DTS to Excel Error

• mayflower1230

  SSC Veteran

  Points: 207

  More actions

  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

• vambati

  SSCrazy

  Points: 2769

  More actions

  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.