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?