Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  DTS Package

Author  Topic  ekingm Starting Member 1 Post Posted - 2006-01-17 : 14:10:52 I trying the edit a DTS package that generates an excel report. I added another column at the end of the report but when I click on the 'Transform Data Task Properties' on the Destination tab, it's defaulting to 'New Table' which was the original and doesn't have the new column I added. I had to create another table, 'New Table1' to include my changes but I have to change the names of the tab on the excel spreadsheet so I can run it more than once without any problems. It doesn't give me an option to delete all existing tables so that when I create the new one, it won't give me a 'Table already exists error'. I already tried deleting the whole thing and start over but I still see the old table out there and it's still defaulting to the one before my update. Any suggestion? I'll appreciate any help. Thanks.