Hi,
I created a DTS package that creates an excel file and send via email. What
I notice was everytime I run the package, instead of overwriting the file, it
appand the new results to the file so I created an active x script task to
delete the file after it is being emaild but next time I run the package I
get the error

"transformed data undefined" The Microsoft jet database engine could not
find the object "New Table". "Make sure the object exists and that you spell
its name and path name correctly".

I then have to manually edit the transformation task by going under the
"Destination" tab and the click the create button to recreate the destination
table. Is there a way not to have that deleted after the activex delete the
file. Or is there another solution avail?

Thanks

Chris
i think you need an execute sql task to create a table for the excel file.
you may want to use import/export wizard and check on Drop Table if existing
and save it as a DTS Package to look at it as a sample.

Edmund

"Chris" wrote:

If you execute a CREATE TABLE statement against the Excel connection it will
create a Named Range/Table/Tab in the spreadsheet for you. If this is the
same definition as was previously defined then there will be no need to redo
mappings.

Allan
www.SQLDTS.com

"Chris" wrote:

Hi,
I am a bit confused here. I my package design mode I have a OLEDB Object, a
MS Excel 97, Send Email, and Active x Script. They flow in the same order.
There is a transformation task between the connection and the excel file
object that selects the data and then dump it to the excel file then the file
is emailed and the active x deletes the file. The problem I have is when I
run the package again I get the error I described earlier and then I have to
edit the transformation between the connection and the excel objects and
recreate the table under the destination.

Thanks

"Chris" wrote:

If you delete your Excel spreadsheet then where is the data going the
second time?

If you are deleting the table then simply recreate it using an
ExecuteSQL task against the Excel connection using a CREATE TABLE
statement.

Allan

"Chris" <Chris (AT) discussions (DOT) microsoft.com> wrote