December 13, 2009 at 6:56 pm
Hey ya,
I've created millions(well what seems like anyway) Dtsx, and I've never come across this one. I'm creating a table within xls and it seems that it has a column limit of 20, if i create 21 i receive the following--
failed with the following error: "Too many fields defined."
Has anyone come across this before and if so was there away around this??
Cheers 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
March 24, 2010 at 6:15 am
I have just had a similar problem with the same error message.
I got around it by changing the name of the sheet that I was trying to create to something different. This worked fine. I think that the package has a definition for that table cached somewhere and the one I'm trying to re-create doesn't match.
so I went from
CREATE TABLE HCP_SCV_RAW
(
`SCV_ID` INT,
`RECORD_SOURCE` NVARCHAR(50),
`RECORD_SOURCE_ID` NVARCHAR(50),
`FORENAME` NVARCHAR(255),
`SURNAME` NVARCHAR(255),
... etc...
`EMAIL_OPT_IN` INTEGER,
`MAIL_OPT_IN` INTEGER
)
to
CREATE TABLE SCV_RAW
(
`SCV_ID` INT,
`RECORD_SOURCE` NVARCHAR(50),
`RECORD_SOURCE_ID` NVARCHAR(50),
`FORENAME` NVARCHAR(255),
`SURNAME` NVARCHAR(255),
... etc...
`EMAIL_OPT_IN` INTEGER,
`MAIL_OPT_IN` INTEGER
)
March 24, 2010 at 5:21 pm
Very interesting, thanks for that Andy 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
August 22, 2017 at 1:29 pm
Thanks for posting this. I just had the same error and was able to easily fix it by replacing the file with an older version and rerunning (with the same new SSIS that was causing this error) after reading this.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply