By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,087 Members | 1,508 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,087 IT Pros & Developers. It's quick & easy.

MSSQL2000 DTS error "Too Many Fields Defined"

benchpolo
100+
P: 142
I am currently modifying an existing DTS process by adding a new field in the Transformation task. This process queries data from SQL tables and import it to MSExcel.

Steps

1. Drop the table
2. Create the table
3. Connect to SQL server and perform data import to excel

When I was testing the new field that I added I am getting this error.

Error Source: Microsoft JET Database Engine
Error Description: Too many fields defined


I only have 18 fields in total defined in my process. Please advise. Thanks.
Dec 20 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.