DTS Packages - Problems with Excel

[RichardHayes]

I am having problems when creating DTS packages to copy data from SQL into Excel (in order to mail spreadsheets to users).

The problem I have is in creating the tables in Excel. I use an "Execute SQL Task" to Drop and Create the necessary table(s) in my spreadsheet. The problem comes when I look at the Destintion list in a "Transform Data Task". Sometimes it creates two options - one of the table name, and one with a dollar ($) after the table name. I have deduced that the dollar means that data will be appended, which is not what I want. Sometimes however it ONLY creates the table with the dollar after it, and I cannot get it give me the standard table.

Please advise if you have experienced this problem or know the solution.

Many thanks, Richard Hayes.

 

[Morpheus1981]

Excel itself has am Import "External Data" from almost any database check your version of excel an see if it has it. I think would be many times easier than a DTS.

 

[RichardHayes]

I am using DTS packages because I can schedule them to be run on a regular basis for daily, weekly, monthly reports etc. Therefore I have to use this method.