I have a dts package to export data from sql to excel. The
package was working fine until I noticed I forgot a
field. I added the field to the properties of create
table but now I am getting the following error:

Too many fields defined

I have tried deleting the last field and I still get the
error message.

Yes, the fields from sql map to the excel fields.

Create table Excel

The transformation don't work because the excel table is
not getting created due to the "too many fields are
defined" error msg.

I finally fixed the problem by deleting the excel file and
creating a new file(workbook). There must have been
something on the excel side that was preventing the
worksheet from being recreated with the new field names.

I was testing this just now and I could quite happily change the definition
of the XL table/worksheet before the datapump and still have the data go
into it from SQL Server


--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org