SQL Server Performance

DTS Excel export works fine......until I amend the SQL script providing the data....

Discussion in 'SQL Server DTS-Related Questions' started by rock_and_roll, Jan 21, 2008.

  1. rock_and_roll New Member

    I can't find an answer to this anywhere.......
    I've created a DTS package that extracts data from a table and exports it to Excel and then emails the spreadsheet to a manager. It all works fine.
    The problem is that the manager than asked me to add a couple more columns to the data being exported, so I changed the layout of the Excel spreadsheet to reflect this and amended my DTS package and added the two columns to my script. But! When I run the package, the coulms are there with the headings, but no data, even though running the script in Query Analyzer works fine and displays all the data.
    Any brilliant ideas out there?

  2. martins New Member

    Did you add the transformations for the extra 2 columns under the "transformations" tab?
  3. rock_and_roll New Member

    Ha ha! No, I didn't! What a dummy!
    Thank you so much for pointing out the obvious..........which now explains why another one I did was OK........I re-mapped all the columns.....
    Doh! Cheers for your help!

  4. martins New Member

    heheh, no problem...happens to everyone at some point [:D]

Share This Page