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.
| Author |
Topic |
|
jigsatics
Starting Member
18 Posts |
 Posted - 2006-01-24 : 14:03:53
|
| Hi!I created a view that displays all the needed fields that I want exported in Excel. My DTS contains a Transform Data task that uses the view as the source. In the destination tab, I used the created button to format the data in the order that I want it and named it as "LiveLabels". Once the DTS is saved, I can execute the DTS without any problems and could also see the generated excel output. The problem arises when I run the DTS again. the DTS appends the data into the excel file instead of overwriting it. Also, if I delete the Excel file and re-ran the DTS, I get an error in the destination tab of the Transform Data Task saying: Error Source: Microsoft Jet Database EngineError Description: The Microsoft jet database engine could not find the object "LiveLabels". Make sure the object exists and that you spell its name and its path correctly.Another thing, when I used the "create" button in the Destination tab and I click on the table name, I always get 2 versions of the table, one is just plain LiveLabels and the other has a $ sign appended to it.$3.99/yr .COM!http://www.greatdomains4less.com |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-25 : 05:47:48
|
| What you need to do is create a template excel file, copy and rename this before executing the rest of your dts. In my last position I used to have to do this all the time. You need to make sure no-one delete's this template else you're screwed though..use an xp_cmdshell call to copy and the rename the template.. |
 |
|
|
|
|
|
Problems exporting excel in DTS