April 9, 2003 at 4:09 pm
Hi all. I'm getting an error in my DTS package, here it goes:
"The number of failing rows exceeds the maximum specified. (Microsoft JET Database Engine (80004005): Cannot expand named range.)"
Please help
April 10, 2003 at 3:52 am
Sounds like you are importing an Access database in your package. Make sure the table being inserted into can accomidate the data that is coming from the Access DB. If any columns width is too small or not null specified and a null value is coming in then you will have issues.
April 10, 2003 at 4:50 pm
there is no Access involved, from SQL 2000 strasight to Excell. I dropped the excell files and re-ran the package, and it worked.
I'm still puzzled though. Oh well.
Thanks for your reply
April 11, 2003 at 1:32 pm
Excel probably has an upper limit of 64K rows and your result probably exceeds that limit. I have seen this error while pasting a huge result in to Excel.
Thanks
April 11, 2003 at 1:41 pm
nope, that wasn't it either.
still searching though
April 11, 2003 at 3:28 pm
Hi,
looks like permission error
Or
are you using text columns data type somewhere?
JFB
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply