"Chris" <Chris@discussions.microsoft.com> wrote in message
news:Chris@discussions.microsoft.com:

> 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:
>
> > 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