Hello Gurus,

Looking for help on a problem which i need to resolve immediatly..Any help
is appreciated .. Sorry if this post is too long..Trying to put as much info
I can.

I have created a DTS package to export some data from SQL Server to an EXCEL
file. The problem I face is that the DESTINATION table need to be created
every time, it doesnt get saved.

The source data is fetched using an SQL Query. (This query works fine and I
could see the data when I preview from SOURCE tab. At the destination
screen, it prompted me to create a 'NEW TABLE' and I did. Then I clicked SAVE
and executed the DTS it worked fine.

If I close every thing and come back later and execute the package, it fails
because "Microsoft Jet database engine could not find object 'New_Table'
Make sure this object exists . blah blah .... "

If I click the destination tab again and create the table, it would work
agian.

I got 2 DTS packages which export data to excel from SQL server table and
facing this issue with both.

Any help is ppreciated.. thanks in advance

And what does the Excel Spreadsheet look like? Have you looked at that?

"Sreejith Ram" <SreejithRam (AT) discussions (DOT) microsoft.com> wrote

Yes i looked at spread sheet. forgot to mention, i have a template
file(with header row) and this transformation should add the result to
the template.

When DTS fails, the template file remains with header row and no data
records.

When I click "Create New Table" on destination tab the template file
get appended with the result data.

Thanks for dropping in..

Allan Mitchell wrote:

After playing around for some mroe time, I found the reason for the
error.

The records are being copied to a template file (XLS) and the Workbook
name is Sheet1. When I renamed the table name at "Destination" tab to
Sheet1, the package started working fine..

This was a newbie error! Hopefully this post helps other newbies...

Thanks for the suggestions and comments...